Great Work folks! Got it to work with all examples....now I just choose one
and go with it! Thanks again!

"Max" wrote:

I posted the response below in your earlier thread
-----------------
As for your new query, my thoughts would be to try something along these
lines, indicatively:

=
IF(ISNA(MATCH(1)),IF(MATCH(2)),
IF(ISNA(MATCH(3)),IF(ISNA(MATCH(4)),
INDEX(ColE,MATCH(4)),INDEX(ColE,MATCH(3)),
INDEX(ColE,MATCH(2)),INDEX(ColE,MATCH(1)))

where 1,2,3,4 would contain the sequential checks on the 4 cols
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"deeds" wrote in message
...
I need to check 4 columns of data for a number....when it finds it in ANY
column it returns the text in column 5. The number will appear in only 1
column but could show up in ANY of the 4 columns. Any ideas?

Thanks in advance