I have a spreadsheet (not mine, it is a shared one created by someone else), it has columns/rows A1 - AW850.

Not every column is populated, but the further most ones are.

So, I need to return the value of the 1st column of 3 which the 3rd column is the value I am looking for.

for example:

Row 185

Columns:

__AU AV AW__

P02 Text 20.07.20

so in the example above: my match formula will find the value 20.07.20 in column AW185, but I need the formula to return the value of the cell that is 2 cells left of the matching value; which would be "P02" in column AU185

but not every column is populated, so AW in row 185 would have 20.07.20, but row 186, column S would be populated with 20.07.20, and so on.

the match formula works to find 20.07.20, but I am stuck on how to return the P02 value.

the P value will always be 2 cells left of the date in every row.

any help would be appreciated.

Wayne