Excel 2003 - I have one spreadsheet with 3 sheets.
sheet 1 is called 2011 contribs
sheet 2 is called 403 election
sheet 3 is called tds earnings
I need a formula to lookup earnings from sheet 3 and put on sheet 1. The problem is that I need the formula to match 2 cols in sheet 3 with 2 cols in sheet 1 before returning earnings.
I need to match up emp (employee nbr) AND ppe (Pay period ending date) from sheet 3 and return the earnings onto sheet 1. I would appreciate any suggestions. Please see attached.