VLOOKUP

[Chris P]

I'm busy on a Excel sheet with the following vlookup
fuction: =VLOOKUP(F38,test.txt!$D:$E,2,FALSE)

This will work if there are not more than 65536 records,
but I want to perform this with more than 150.000 records
so that I have to make more than 2 colums e.g. column D &
E, column G & H and column J & K.

Is this possible ?

Thanks for your help

Chris...

 

[J.E. McGimpsey]

One way:

=IF(ISNA(MATCH(F38,D,FALSE)), IF(ISNA(MATCH(F38,G:G,FALSE)),
IF(ISNA(MATCH(F38,J:J,FALSE)), "", VLOOKUP(F38,J:K,2,FALSE)),
VLOOKUP(F38,G:H,2,FALSE)), VLOOKUP(F38,D:E,2,FALSE))