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