Forum Discussion
Help with with Lookups etc.
Hi I’m looking for help as I’ve exhausted my knowledge and cannot sort this out. I have a spreadsheet with columns A-L. The sheet goes from A2:L90 (see attachment) Columns A and B are surname and...
If you do not have Excel 365 or Excel for the web, this may still be possible. (And macros are to be avoided if possible.)
If you have Excel 2021 or a later version, see the attached workbook. (If you do not have Excel 365 or Excel for the web, you will probably need to remove the Data Validation from the input cell (D2) on the Demo worksheet.)
Edited: Yet another example of when I attached a file, but the forum software dropped it.
Hi SnowMan55,
This looks very professional. I'll try it out tomorrow.
Thank you.
