Forum Discussion
Solved
Formula help for tables that columns may change positions
Hi I have created the below formula in column S (report number) to bring through a report number. =VLOOKUP(Table_query__1[Title],Lists!Q:R,2,FALSE) The whole data table in Table_query_1 i...
Hello, try this:
=XLOOKUP(Q7,Table1[Title],CHOOSECOLS(Table1,MATCH("Report N.",Table1[#Headers],0)))You will only have to write the name of the column header of the values you want to return. Then, even if changes in columns are made, it will always find the value to return.
Attaching a sample document for you as well.
Martin
thank you! that worked perfectly.
I need to do another one - I've got a cell named "Phase No" in I3 that I want to bring through all the column data into I4:I180 from a table that has the header name "Phase No". Is it an issue that the data in I3 isn't a table? I'd prefer not to change it to a table if possible, however the table that I'm pulling the data from needs to stay as a table.
I need to do another one - I've got a cell named "Phase No" in I3 that I want to bring through all the column data into I4:I180 from a table that has the header name "Phase No". Is it an issue that the data in I3 isn't a table? I'd prefer not to change it to a table if possible, however the table that I'm pulling the data from needs to stay as a table.
If you use Power Query to get initial data from MS list, entire job could be done with Power Query without additional formulae.