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),MAT CH(Prices!A14,B2:I2,0))

Can anybody help ?

Maybe

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


--
HTH

Bob Phillips

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

"Bob Moore" wrote in message
...

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),MAT CH(Prices!A14,B2:I2,0))

Can anybody help ?




--
Bob Moore

Looks to me like it should be

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

"Bob Phillips" wrote:

Maybe

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


--
HTH

Bob Phillips

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

"Bob Moore" wrote in message
...

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),MAT CH(Prices!A14,B2:I2,0))

Can anybody help ?




--
Bob Moore