Matching a two way lookup

[sk1mcguire]

Hey Folks!

I have a table where I have the employee number on the left and their available leave balances on each row.

What I ultimately need is the unique employee ID which I have and the value of the leave balance that matches in the columns to the left.

What is the best formula to employ to accomplish this task?

Many thanks in advance!

Very Respectfully,

Jonathan

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I	J	K
1						AL	alx	holcomp	illness	vacation	fal
2	123	AL	24		123	24		8	1385.8175	583.077
3	123	comp	367.5
4	123	holcomp	8
5	123	illness	1385.8175
6	123	vacation	583.077
Sheet1

Cell Formulas
Range	Formula
F2:K2	F2	=IFERROR(INDEX($C$2:$C$6,MATCH($E2&"|"&F$1,INDEX($A$2:$A$6&"|"&$B$2:$B$6,0),0)),"")

 

[sk1mcguire]

Thank you Fluff!!!

I would have NEVER conceived of that !!

Cheers from across the pond!

Jonathan

 

[Fluff]

You're welcome & thanks for the feedback