What do you mean by ‘preceding cells’.
Above the cell whose value you want to return? to the left of it?
You can do a vlookup where the lookup value is concatenated e.g
=VLOOKUP(G2&H2,A:C,3,FALSE)
but the first column of the range has to be one cell (e.g. G2 is “single” and H2 is “track” so it will only find a match if a cell in column A contains “singletrack”
I’d make a big concatenated cell that picks up everything relating to that line e.g.:
=A2&”¦”&B2&”¦”&C2&”¦”&D2 etc
and do the same in the destination sheet, then do the lookup or match & index between those two cells rather than trying to do it on a range.