Mar 11 2021 04:19 AM
Can someone help me understand how to perform a VLOOKUP on new columns that are inserted into a table?
I want to insert new date columns in between BP and BQ, so when the vlookup is performed it pulls through the last three columns. When a new one is inserted, this will need to be considered as the latest three?
Thanks
Mar 11 2021 05:41 AM
Mar 11 2021 05:44 AM
Mar 14 2021 01:30 AM
Thanks @Jan Karel Pieterse
So when I add a new column between column L and M on sheet 2, the table within sheet 1 automatically pulls the latest 3 columns highlighted yellow (columns D - I on sheet 1).
Then when a column is inserted after column Q on sheet 2, the 3 latest columns are pulled through to the table within sheet 1 (columns J-L in sheet 1).
Please find sample data attached.
Thanks.
Mar 15 2021 02:38 AM
@milo1234 I think you asked for the attached, but I'm not 100% sure. Please note that this assumes you are using Excel 365.
Mar 15 2021 02:42 AM
Mar 15 2021 03:13 AM
Mar 15 2021 04:50 AM
SolutionMar 15 2021 07:04 AM
Mar 15 2021 04:50 AM
Solution