Forum Discussion
Solved
VLOOKUPS with new columns inserted
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 pu...
- Hi Jan,
Thanks this works - but I will be adding columns after column R on sheet 2 continuously. Will this affect the date?
Also, I want the dates in columns D-I on sheet 1 to automatically pick up the last 3 date columns too.
Hi Jan, would you able to provide an example formula please?
Sure, if you provide a sample sheet 🙂
Thanks JKPieterse
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.milo1234 I think you asked for the attached, but I'm not 100% sure. Please note that this assumes you are using Excel 365.
- Hi Jan, thank you for providing the example formulas.
Can the date column headings within sheet 2 not be merged? Will this cause a problem?
Also, the dates on sheet 1 will need to change to pick up the latest 3 columns on sheet 2.
Please could you help me with this?
Thank you 🙂