INDEX and MATCH functions...formula audit please

Hello

I am trying to use the following formula:

=INDEX($J$2:$R$4698,MATCH("City",$B$2:$B$4698,0),MATCH("style",$C$2:$C$4698,0),MATCH("price",$J$1:$R$1,0))

So there's my formula, i simply put in the city/style/price because each cell formula will be a unique city/style/price.

Now i am using this on 1 cell and it works fine. The minute i try and go down to the next cell which changes the city/style/price level i get a #REF error.

I don't understand how it can work for 1 and not for the other since the ranges are correct. What could be my problem? I have a hunch it is with the "price" column because i can write the same formula however only match 2 out of the 3 criteria and define a SPECIFIC index for each of the 8 pricing "levels" and it will work. But the minute i try and go 3 to make my index simple 1 range i get the error.

Help.

PS for some reason in the post the one "match" is coming up like it has a space in it even though when i type it, it doesn't. So that isn't the problem. Thanks

I found out why....INDEX+MATCH cannot go more than 1 column at a time and i'm trying to cover 8 columns at once. That's why it worked going column by column but not when doing all of them at once.

Hello Jim,

Are you trying to find the value at the intersection of the row that matches "City" and "Style" and the column that matches "Price"? If so check out NBVC's suggestion above.....looks good to me