Another one...

Data to be reurned in the range E1:E10
Numbers in the range A1:D10

Lookup number in H1

Array entered** :

=INDEX(E1:E10,MATCH(1,--(MMULT(--(A1:D10=H1),{1;1;1;1})0),0))

This is limited to ~5460 rows of data.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"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