Lookup in Two Columns, Help needed with formula
In a page €śHistory€ť I have three columns of data (50,000+ rows) Name, Date
and Salary, and in a separate Page €śMonthly€ť I have Name, Monthly Pay Date
and Monthly Salary.
Working in €śMonthly€ť I need a formula to look in €śHistory€ť to find the
person in Name and within their list of dates find the correct pay.
This is an example of €śHistory€ť:
Name Date Salary
Brown 01/Sep/99 750
Brown 01/Jan/00 1000
Brown 01/Mar/01 1500
Brown 05/Jun/03 2000
Brown 07/Sep/04 2200
Brown 01/Oct/05 2500
Black 01/May/05 2500
Black 01/Sep/06 3000
If the pay date is 01/Oct/00 and the employee is Brown, I need a formula to
find Brown and then establish his pay rate which would be 1000 as at
01/Jan/00.
I hope this is clear!
|