more than a standard lookup

[Greenmachine]

What I want to do is enter "a" in one cell, and "blu" in another cell and have it return the number 5. Or if I have "d" and "green" return the number 12. How do I get the result to automatically update from what I put in the letter and color cells?

letter: b
color: red
result: 2


red blu green
a 1 5 9
b 2 6 10
c 3 7 11
d 4 8 12

Thank you all so much.
Billy

 

[NBVC]

Try this:

Book1
	A	B	C	D	E	F	G	H	I
1		red	blu	green
2	a	1	5	9			letter:	d
3	b	2	6	10			colour:	green
4	c	3	7	11			result:	12
5	d	4	8	12
6
Sheet1

Formula in H4: =INDEX($B$2:$D$5,MATCH($H$2,$A$2:$A$5,0),MATCH($H$3,$B$1:$D$1,0))

adjust ranges and references to suit.

 

[lenze]

Use Index Match

=INDEX(B2:D5,MATCH(G1,A2:A5,0),MATCH(G2,B1:D1,0))

lenze

 

[Greenmachine]

Thank you very much.