vertical & horizontal lookup?

[CommSecy]

So similar to a multiplication table, I want to be able to find the horizontal and vertical match. I have a list of employees with the number of years as of a specific date, i want to find their salary based on the number of years and grade. so based on their grade, and the number of years working, their salary should be X.

Thanks

 

[Toadstool]

Hi Commsecy,

I think a worked example would help you get better answers but I'm guessing the employees also have grades and the years of service are ranges for the salary.

CommSecy.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Employee	Years	Grade	Salaries				Years
2	Bob	1	A	€65,000			Grade	1	3	7	25	99
3	Jim	4	B	€72,000			A	€65,000	€80,000	€90,000	€120,000	€145,000
4	Sue	7	C	€72,000			B	€56,000	€72,000	€82,000	€98,000	€102,000
5	Kim	12	A	€90,000			C	€48,000	€66,000	€72,000	€86,000	€96,000
6	Alex	3	B	€72,000
7	Vanessa	26	A	€120,000
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=INDEX($H$3:$L$5,MATCH(C2,$G$3:$G$5,0),MATCH(B2,$H$2:$L$2,1))

 

[CommSecy]

Thank you, Thank you, Thank you!!!

Wait...did I say THANK YOU?!?

 

[Toadstool]

Thank you, Thank you, Thank you!!!

Wait...did I say THANK YOU?!?

You're welcome!
Thanks for the feedback.