Harlan,

Thanks a lot - works like charm.

KL

"Harlan Grove" wrote in message
...
"KL" wrote...
Thanks a bunch - that works. Now out of curiosity: what should I be doing
if I have numbers or a mix of numbers and text?
...
=VLOOKUP(B1,Sheet2!$C$1:$J$10,{1;5;6;7;8},0)
=T(INDIRECT({"B1";"F1";"G1";"H1";"J1"}))

If there's an unpredictable mix of text and numbers, the most robust way
to
handle that would be

=(VLOOKUP(B1,Sheet2!$C$1:$J$10,{1;5;6;7;8},0)
=T(INDIRECT({"B1";"F1";"G1";"H1";"J1"})))
+(VLOOKUP(B1,Sheet2!$C$1:$J$10,{1;5;6;7;8},0)
=N(INDIRECT({"B1";"F1";"G1";"H1";"J1"})))

which will return 1s instead of TRUEs and 0s instead of FALSEs.