Hi All,
I have got this formula which i'm using, but i only have it on one row at the minute, i want to copy the formula down multiple rows but without changing the Index Match cells only changing one cell reference for example I3 would be become I4.
=IF(I3*1.25>DATA!I60,"DISTBLOCK",INDEX(DATA!I5:I20,MATCH(TEMPERATURES!I3,DATA!J5:J20)))
I have over 100 rows on my worksheet so don't want to have to go down each row and change the cells.
Any help would be appreciated.
I have the same problem with this formula as well. i only want to change AB3 to AB4 for example.
=VLOOKUP(AB3,DATA!I5:K20,COLUMN(DATA!K5:K20)-COLUMN(DATA!I5:K20)+1,0)
you need to make the cell references absolute. Just highlight the cell reference, eg 5:I20, and press F4. This will put $ signs before the column and row.
EG
VLOOKUP(AB3,DATA!$I$5:$K$20,COLUMN(DATA!$K$5:$K$20)-COLUMN(DATA!$I$5:$K$20)+1,0)
Isskint, i get satisfaction out of helping others
Thank you, can not believe it was so simply!
nathan,
useful to know about the differences between absolute and relative cell references. You can also just 'fix' either the column or row if needed. $A1 when copied would always show column as A but on other rows the row number would change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks