Hello,
I need help having a VLOOKUP formula refer to an array dynamically, that is to say it looks through the array starting at different points based on a row number that I have updating from other data inputs.
=VLOOKUP(LEFT($B$19,15)&"*",'FILENAME'!$B$2:$H$548938,1,FALSE)
I need the underlined area to be based off another cell, so for example I can update the other cell to say B52, and I need the B2 to update to B52. Is this even possible? If yes, how can I get this to work?
I tried using INDIRECT to point to a cell that I would update but I get an incorrect formula error when trying to enter it.
I need help having a VLOOKUP formula refer to an array dynamically, that is to say it looks through the array starting at different points based on a row number that I have updating from other data inputs.
=VLOOKUP(LEFT($B$19,15)&"*",'FILENAME'!$B$2:$H$548938,1,FALSE)
I need the underlined area to be based off another cell, so for example I can update the other cell to say B52, and I need the B2 to update to B52. Is this even possible? If yes, how can I get this to work?
I tried using INDIRECT to point to a cell that I would update but I get an incorrect formula error when trying to enter it.