Excel vlookup problem

  • Thread starter Thread starter oa6n
  • Start date Start date
O

oa6n

Is it possible to use the vlookup function using 2 criteria? For exampl
I would like to vlookup a value for a date and an ID number
 
Hi
one way:
- create a helper column in your lookup table consisting of a
concatenated string of date + ID number (you can hide this column)
- search for this concatenated string

another way:
=INDEX(C2:C10,MATCH(1,(A2:A10=date_value)*(B2:B10=id_number),0))
where column C holds the return value and A and B the date/ID number

HTH
Frank
 
oa6n
Your welcome. Also, I have often used the technique in Frank's first suggestion, this is a very straightforward way to get a double lookup without getting lost in a bunch of INDEX and MATCH functions

Regards
Mark Graesse
(e-mail address removed)

----- oa6n > wrote: ----

Thank you! this was extremely helpful
 
Back
Top