Vlookup with a specific item

  • Thread starter Thread starter kattay
  • Start date Start date
K

kattay

Hi, I would like to vlookup on employees' degree start date, eg.:

A B C
emp. no. Start date Edu
1 01/01/90 Dip
1 01/01/95 Deg
2 01/01/82 Cert
2 01/01/86 Dip
2 01/01/90 Deg

How do I vlookup on the emp. no and deg start date?
Thanks in advance.
 
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

With emp. no. in cell D2 and Start date in cell D3 try the below formula

=INDEX(C2:C10,MATCH(1,(A2:A10=D2)*(B2:B10=D3),0))
 
Back
Top