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 is data that will be pasted in every time I do a new report. This is data exported from MS lists that has the same column header names, however the column order may change (this is unavoidable). So [Title] in Table_query_1 may end up in column U, W or X etc when pasted in. 

The “Lists” in column Q match the names in [Title] (there’s a total of 177 lines) and column R is the report number I need to bring through that’s based off column Q.

I have just tested pasting in new data where the [Title] column was not in the same column and it has thrown my formula out.  How can I avoid this from happening? I’ve looked into doing a match and index, however I’m finding it difficult to navigate it.

​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 is data that will be pasted in every time I do a new report. This is data exported from MS lists that has the same column header names, however the column order may change (this is unavoidable). So [Title] in Table_query_1 may end up in column U, W or X etc when pasted in.  The “Lists” in column Q match the names in [Title] (there’s a total of 177 lines) and column R is the report number I need to bring through that’s based off column Q. I have just tested pasting in new data where the [Title] column was not in the same column and it has thrown my formula out.  How can I avoid this from happening? I’ve looked into doing a match and index, however I’m finding it difficult to navigate it.  Read More

​