Index Match/Range Names/Indirect

[billyshears]

Worksheet A I have a range named "CODE"
Worksheet A i have a range named "PRICE"

on Worksheet B, I want to have an index/match formula that will result in an answer from the "PRICE" range based on a variable that matches with data in "CODE". I tried using the following but it does not seem to work:

What am I doing wrong?

=INDEX(INDIRECT(PRICE),MATCH(D15,(INDIRECT(CODE))))

 

[Z51]

The Index/Match function is similar to other lookup functions in that it returns one value from a table based on the lookup value. Not sure why you need to use INDIRECT here, as it can just be:

=INDEX(PRICE,MATCH(D15,CODE,0))