Need help using Index and Match for table lookup with 2 criteria matching

**lorne17** · 09-26-2012, 08:13 PM

Hello there,

I posted at the end of another post I started, but I think it may classify as a new question.

I'm trying to get cell F16 in my attached file to reflect the price in the table above if the numbers in D16 and E16 match the criteria.

This is the formula I'm using:

Please Login or Register  to view this content.

Thanks in advance,
Lorne

**FDibbins** · 09-26-2012, 08:46 PM

change your formula to...
=INDEX($B$3:$K$9,MATCH($E$16,$B$3:$B$9,0),MATCH($D$16,$B$3:$K$3,0))

the 1st part of your index was correct, but you need to match() functions - 1 for the row and 1 for the column

**lorne17** · 09-27-2012, 09:09 AM

That worked great! Thank you! I knew I was close

**lorne17** · 09-27-2012, 09:14 AM

Also, this is a solution where I just need to hit enter.

Please Login or Register  to view this content.

**Fotis1991** · 09-27-2012, 09:26 AM

I really don;t understand why you send same question twice.

Yesterday we tried hard some people to help you.

So this is a duplicate post!

http://www.excelforum.com/excel-form...onditions.html

**lorne17** · 09-27-2012, 09:38 AM

Sorry Fotis,

I've been yelled at before for posting a second question on a thread that had a different topic, so since we changed the equation and the solution changed from the earlier solutions on the other post, I thought after posting it I should probably post another one.

I have been actively involved and thankful for everyone's help! Sorry to duplicate posts, and thanks for the help from all! These forums really are great

Lorne