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
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