Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Formula needed to compare columns | New Users to Excel | |||
Lookup Data in Several Columns | Excel Worksheet Functions |