| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to change a MATCH formula when moving it to a different sheet
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Is it possible to change a Sheet reference in a formula? | Excel Discussion (Misc queries) | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Threaded Mode
