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 ...
The setup isn't ideal for any kind of regular lookup function, but provided your Excel supports TEXTJOIN, the attached workbook contains a solution that works.
Hi Riny,
Looks like my reply yesterday never saved.
Many thanks, I would never have thought of that formula, you've saved me lots of time!
Initially I found that the formula gave me a "#Value!" message, but 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!