Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another VLOOKUP Problem
Hello again,
I'm tearing my hair out here and hope someone can help me (please)! I need to use a VLOOKUP within a VLOOKUP. Below is the layout of my data. Year data (G4:H8) is named YEAR and the other cell range (A3:M13) is named SALARIES A3 Salaries by Scale G4 G5 Year 1 Year 2 Year 3 Year 4 Year Column Scale 0% 5% 7% 9% 1 2 2 3 A £7,000.00 £7,350.00 £7,864.50 £8,572.31 3 4 C £7,200.00 £7,560.00 £8,089.20 £8,817.23 4 5 E £7,500.00 £7,875.00 £8,426.25 £9,184.61 G £7,700.00 £8,085.00 £8,650.95 £9,429.54 I £8,100.00 £8,505.00 £9,100.35 £9,919.38 K £9,000.00 £9,450.00 £10,111.50 £11,021.54 M £10,000.00 £10,500.00 £11,235.00 £12,246.15 Employee Scale Year Salary Joe A 2 formula here to calculate the salary based on year of service and scale Sue C 3 Dave J 1 Stu K 4 John L 3 I'd really appreciate someones kind help. -- Cheers, V |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Problem | Excel Discussion (Misc queries) | |||
VLOOKUP PROBLEM | Excel Discussion (Misc queries) | |||
VLOOKUP problem with using a - | Excel Worksheet Functions | |||
Vlookup problem.. | Excel Worksheet Functions | |||
VLookup Problem | Excel Discussion (Misc queries) |