A classical formula might be =HLOOKUP(a1,a100:z100,1,FALSE). But I want to
display the result if the lookup value = a1 or a2 or a3 or...a10 ie: anything
in the range a1.a10, without writing a multiple nested statement. Any ideas?
Thanks.
--
Peter
London, UK