Multiple Lookup Criteria

[tigershoes]

Hello,
Have payroll data where I need to lookup 2 criteria: name and a code (representing Holiday (16 is the code), Sick/Personal (E is the code) or Vacation (V is the code) from SHEET B and then take the corresponding cell value on SHEET B and place it on SHEET A. Can't seem to get a lookup formula to work. The columns always remain the same but the rows may change depending if an employee has taken any time off.
SHEET A
Montalvo, Joanna Allowed Amt Taken Amt Balance Amount
Flt / Holiday (16) 8.00 8.00 0.00
Personal / Sick (E) 40.00 40.00 0.00
Vacation (V) 120.00 120.00 0.00

Ramsey, Julia A Allowed Amt Taken Amt Balance Amount
Flt / Holiday (16) 8.00 0.00 8.00
Personal / Sick (E) 40.00 6.00 34.00
Vacation (V) 80.00 14.00 66.00

Whitner, Calvin A. Allowed Amt Taken Amt Balance Amount
Flt / Holiday (16) 5.00 0.00 5.00
Personal / Sick (E)
Vacation (V) 40.00 0.00 40.00


SHEET B
746139 Ramsey, Julia A 21690
Code Allowed Amt Taken Amt Balance Amount
16 8.00 0.00 8.00
E 40.00 6.00 34.00
V 80.00 14.00 66.00
746184 Montalvo, Joanna 21290
Code Allowed Amt Taken Amt Balance Amount
16 8.00 8.00 0.00
E 40.00 40.00 0.00
V 120.00 120.00 0.00
746248 Whitner, Calvin A. 21401
Code Allowed Amt Taken Amt Balance Amount
16 5.00 0.00 5.00
V 40.00 0.00 40.00

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
This will be easier to resolve for you versus having to re-type all your data and guessing as to what you have as data types.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic