Hi all,

Hoping someone can help me with this one.

My workbook consists of the following:
Sheet1 = Incomplete data but has unique values that are contained in Sheet2 and Sheet3
Sheet2 = First table of data
Sheet3 = Second table of data

In Sheet1, I've used an IFERROR to vlookup Sheet2, and if there's an error, vlookup Sheet3.

It's pulling through all ok, until I go to sort the data.

When I sort, my lookup_value does not move with the sorted cells and acts as if it's a relative reference.

Has anyone else come across this before? Alternatively if anyone can help with a different formula that would be great.

Thanks,
JF