Hi,
I have a sheet with data
Column A:A contains the reference name "eg. Mona"
Column B:XX contains the data "e.g. 3200"
The user will just add data to the last column available (currently empty), each time he/she adds data.
I want to have a dynamic Vlookup formula, that always will pick up the data in the last 5 columns in the data sheet.
There might be a better solution to the problem, however I've created a formula that dynamically gets the titles of the last five columns used in the "data" sheet. And from this information and the reference name in cell eg. A1 I'm trying to create a Index and Match formula that will get the correct cell from the "data" sheet, however this formula ain't working!
Can you please help with the index match formula so that it finds both the reference name in range "Data!A:A" and the column name in range "Data!6:6", so to give me the value in eg. "Data!G20"
Or I'm open to better solutions
Bookmarks