I'm using this formula
=VLOOKUP($C12,'[2024 Plants.xlsx]Garden'!$B$14:$BU$137,21,FALSE) and it works perfectly but I need to drag it across about 200 columns and manually have to change the 21 to 22, to 23 to 24 and so on. With 200 columns this takes a while. Am I stuck doing it that way or is there way to do it by dragging the formula?
Thanks in advance
=VLOOKUP($C12,'[2024 Plants.xlsx]Garden'!$B$14:$BU$137,21,FALSE) and it works perfectly but I need to drag it across about 200 columns and manually have to change the 21 to 22, to 23 to 24 and so on. With 200 columns this takes a while. Am I stuck doing it that way or is there way to do it by dragging the formula?
Thanks in advance