Formula to retrieve item cost based on two variables in database

[dwsteyl]

Hi guys

I'm sure this question must have been asked before, but I couldn't find a solution searching previous answers.

I have an Excel database like this:

Initial	Name	Item1	Item2	Item3	Item4	Item5
dws	Dietrich	10	20	30	40	50
mz	Mary	20	25	35	45	55
im	Ingrid	30	36	46	56	66

<tbody>
</tbody>

I need to retrieve the value of an item based on input in two cells, like this:

mz

Item3

??

<tbody>
</tbody>

I need a formula in the third cell that can cross reference the initial ("mz" in this case) with the item code ("Item3") and pull through the correct value (in this case "35") to cell 3.

In my real scenario I have about 12 employees with approximately twenty items. I therfore assume that the formulas can be used to reference to a range (the table in this instance), but this is not a neccesity (only an option to make the formulas easier).

Thank you for your help!

Regards
Wessel

 

[FDibbins]

Maybe something like this?

	A​	B​	C​	D​	E​	F​	G​
1​	Initial	Name	Item1	Item2	Item3	Item4	Item5
2​	dws	Dietrich	10	20	30	40	50
3​	mz	Mary	20	25	35	45	55
4​	im	Ingrid	30	36	46	56	66
5​
6​
7​
8​	mz	Item3	35

C8=INDEX($C$2:$G$4,MATCH(A8,$A$2:$A$4,90),MATCH(B8,$C$1:$G$1,0))

 

[dwsteyl]

FDibbins

That works perfectly! Thank you very much for the help.

Regards
dwsteyl

 

[FDibbins]

Happy to help