Thread: Lookup array?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBj
 
Posts: n/a
Default Lookup array?


Probably a peace of cake, but I can't work it out...

I have an array of values in the area A1 to B3.

I want to know if any cell in the array A1:B3 contains eg. value 5?

LOOKUP or INDEX or MATCH?

HBj