Thread: more than one lookup value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkN
 
Posts: n/a
Default more than one lookup value
What result do you want??
--
Thanks,
MarkN


"R..VENKATARAMAN" wrote:

this is trivial example
1-May 1
1-May 2
1-May 3
2-May 4
3-May 5

the formula
=LOOKUP(A1,A1:A10,B1:B10)
gives 3 and not 1 or 2. why?





Reply With QuoteReply With Quote