Lookup question

[normpam]

Have a list with something like this:
Affiliate - WFG
COAOR
FLAOR
LynnR
NCP

Any one of the above may appear in a horizontal list of maybe 70 different columns. What would be the best way to find any one of the vertical listed items, and return that item if it does appear in the horizontal list? Does this make sense?

 

[awoohaw]

Please post a mini workbook with examples of the scenarios you describe using the xl2bb add in? (Link below).

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)