Thread
:
Lookup array?
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
HBj
Posts: n/a
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
Reply With Quote