Can you have two vlookups in one statement? Tab A has 3 columns, EMP #, GROSS
PAY, and DATE.

See the chart below. Say i want to a cell to tell me the gross pay of emp
#1550 on 01/22/10, how would the formula be?

EMP# GROSS PAY DATE
1550 $1000 01/08/10
1582 $1530 01/22/10
1550 $1643 01/22/10