Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Sample Data:
Spreadsheet 1 Check # Check Dt Name Tot Gross Total Ded. Total Taxes Net Pay 123456 2005-09-16 Doe, John 1,794.62 196.40 206.38 1,391.84 Spreadsheet 2 Check # Check Dt Name Plan Typ Deductn Cd Ded Class Curr Dedn 123456 2005-09-16 Doe, John Life BASLIF Before-Tax 1.15 123456 2005-09-16 Doe, John Medical GRBOSN Before-Tax 51.68 123456 2005-09-16 Doe, John Retirement Plans ORPAET Before-Tax 143.57 123456 2005-09-16 Doe, John Retirement Plans TRSL01 Before-Tax 0.00 123456 2005-09-16 Doe, John Life BASLIF Nontaxable Benefit 1.15 123456 2005-09-16 Doe, John Medical GRBOSN Nontaxable Benefit 155.04 123456 2005-09-16 Doe, John Retirement Plans ORPAET Nontaxable Benefit 285.34 123456 2005-09-16 Doe, John Retirement Plans TRSL01 Nontaxable Benefit 0.00 Spreadsheet 3 Check # Check Dt Name Tax Class St Curr Tax 123456 2005-09-16 Doe, John FICA Med Hospital Ins / EE $U 25.26 123456 2005-09-16 Doe, John Withholding $U 147.04 123456 2005-09-16 Doe, John FICA Med Hospital Ins / ER $U 25.26 123456 2005-09-16 Doe, John Withholding LA 34.08 Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
VLookup and HLookup at the same time | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel |