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