Retrieve data if reference data exists

[juriemagic]

Hi good people!,

I am sitting with a major headache. I have 3 columns, A, F and K with numbers. The max rows populated is 20 000. Duplicate numbers could be present in all three columns, or any two columns. Naturally, the columns contain distinct numbers as well. I now have in column M a unique list of these numbers. ....
guys, please ignore this thread, I cannot post attachments as the attachment functionality on my pc does not work...it's VERY difficult to explain what I need...thank you anyways..

[xlnitwit]

Hi,

A simple method is to use IFERROR with VLOOKUP:

=IFERROR(VLOOKUP(K3,table3,2,FALSE),IFERROR(VLOOKUP(K3,table2,2,FALSE),VLOOKUP(K3,table1,2,FALSE)))

The tables must be listed in reverse order to obtain the latest results.

[juriemagic]

I think I know why you are known as "xlnitwit"..because you're awesome!!!..thank you very very much!!