How to change a MATCH formula when moving it to a different sheet

[Bob Moore]

Thanks to inputs on this forum (from Ron and DLLEGS), I have managed to
get my formula working which gets a price band from a table consisting
of Apartment codes versus Length of Stay.

Formala is listed below :-

=INDEX(B3:I9,MATCH(A13,A3:A9,0),MATCH(A14,B2:I2,0))

This formala is on the third sheet of my workbook. First sheet = Input.
Second sheet = Invoice and Third sheet = Prices.

When I copy and paste the formula to the first sheet it obviously
doesn't work as it needs to reference a different sheet. I tried the
formal below but this don't work and i'm a bit stuck now.

=INDEX(Prices!B3:B19,MATCH(Prices!A13,A3:A9,0),MATCH(Prices!A14,B2:I2,0))

Can anybody help ?

 

[Bob Phillips]

Maybe

=INDEX(Prices!B3:B19,MATCH(A13,Prices!A3:A9,0),MATCH(Prices!A14,B2:I2,0))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[daddylonglegs]

Looks to me like it should be

=INDEX(prices!B3:I9,MATCH(A13,prices!A3:A9,0),MATCH(A14,prices!B2:I2,0))