Lookup price in a table

[mick418]

Hey all,

I'm trying to do a query on the following table:

Please Login or Register  to view this content.

The result I want is if column a = 5 & column b = c then return $90.00. If anyone could help I would greatly appreciate it. If you need a better example I can attach a file. Thanks in advance.

Michael

[JBeaucaire]

INDEX/MATCH.

Assuming that table in M1:Q10, the formula in C2 would be:

=INDEX($N$2:$Q$10, A2, MATCH(B2, $N$1:$Q$1, 0))




If you wanted to be able to put "bell" in A2 instead of 5, the formula would be:

=INDEX($N$2:$Q$10, MATCH(A2, $M$2:$M$10, 0), MATCH(B2, $N$1:$Q$1, 0))