I am downloading the "Data" report from the system, in which the order of the columns may be different, but their headers will always be the same and the first "ID" column will always be the first. I need values to be displayed in the "Report", where from the "data" sheet it will search for a value where the row will always indicate the first column with "ID", and then in the entire sheet "data" it will find a column with the same header as in the "report "and matches the value. Something like a vlookup, only without specifying column indexes. Tried on with query, but can't figure it out.
=QUERY(Data, "select * where A = """&$A3&""" and F Matches """&F1&"""",0)