I have following tables:
<tbody>
</tbody>
<tbody>
</tbody>
I would like to create a formula that looks up for Employee # and date (first two columns) from the first table and give the results from the second table.
Vlookup(Employee#1 and 07.07.2010) should give me 14
Vlookup(Employee#1 and 06.06.2011) should give me 18
Vlookup(Employee#1 and 08.08.2012) should give me 20
Vlookup(Employee#2 and 08.08.2010) should give me 14
Vlookup(Employee#2 and 08.08.2011) should give me 18
I am looking forward for your support
Thank you
Cheers!
Employee # | Annual Leave Date |
1 | 07.07.2010 |
1 | 06.06.2011 |
1 | 08.08.2012 |
2 | 08.08.2009 |
2 | 08.08.2010 |
2 | 08.08.2011 |
<tbody>
</tbody>
Employee # | Paid Leave Date | Days |
1 | 5.5.2010 | 14 |
1 | 5.5.2011 | 18 |
1 | 5.5.2012 | 20 |
2 | 6.6.2010 | 14 |
2 | 6.6.2011 | 18 |
<tbody>
</tbody>
I would like to create a formula that looks up for Employee # and date (first two columns) from the first table and give the results from the second table.
Vlookup(Employee#1 and 07.07.2010) should give me 14
Vlookup(Employee#1 and 06.06.2011) should give me 18
Vlookup(Employee#1 and 08.08.2012) should give me 20
Vlookup(Employee#2 and 08.08.2010) should give me 14
Vlookup(Employee#2 and 08.08.2011) should give me 18
I am looking forward for your support
Thank you
Cheers!