Forum Discussion
Lookup seat number on table plan
Hello all, hope you can help me. In Excel, I've a table plan where I've assigned names to numbered seats. I now want to read the 'read' that table plan and create a list that tells me the name and ...
Hi Riny,
Update - I found that by clicking on the formula in the formula bar, and pressing CTL-SHIFT-ENTER, the correct value would appear. I could then copy this all the way down the list. Do you know if there's any automatic way of doing it? If not, it's something I can live with, as the rest of it is a massive improvement.
Thanks again!
Are you on Excel 2019 perhaps?
