Forum Discussion
Solved
Flash Fill VLOOKUP
I enter a 3 letter reference in Column E... Column F performs a VLOOKUP and reports. Column P has a basic "=" rule applied from E. After a few rows of doing this, my worksheet has been automatic...
- Try this: Select a cell in either non-functioning column that contains the correct formula. Press control+spacebar. Then hit F2 followed by control+Enter. That should convince the table that that formula "belongs" in that column. Repeat for any other column with a formula.
This is an autocomplete option. If you convert your range (including columns F and P) to a table and make sure all rows of the table for columns F and P contain the formula, it will continue to work as you add new data to the table.
Tip: don't make your table larger than the data. As soon as you type new data immediately beneath or to the right of the table, the table expands automatically.
Tip: don't make your table larger than the data. As soon as you type new data immediately beneath or to the right of the table, the table expands automatically.
- JKPieterse
Thanks so much for your reponse. I have taken those steps and unfortunately it still will not continue downwards. Even the table does not expand when I go to the next row down.
I did try your method on a brand new workbook and it works fine, so it must be something wrong with my current workbook, rather than a general Excel error... or my error lol- Try this: Select a cell in either non-functioning column that contains the correct formula. Press control+spacebar. Then hit F2 followed by control+Enter. That should convince the table that that formula "belongs" in that column. Repeat for any other column with a formula.
- Oh my gosh, you nailed it!!
Thank you so much!
All working perfectly, so happy, thank you x
