Forum Discussion
Solved
Using Formulas to search multiple columns for one criteria & generate a list
Hey all! I hope I'm able to type this in a way where it makes sense. For my job, I'm trying to fix up our list of interpreters to make it easier to navigate. There are currently three sheets: the...
mathetes hey John, not to give you a hard time but I guess you are so lazy you forgot to attach your workbook. LOL. Sry I couldn't resist the poke. But seriously, I absolutely agree with you that another format would be much more efficient so updated my sheet with a recommended format. I'm curious how closely it will match your sheet.
You took it all to the next level. Great job!
The only "improvement" left would be to put the basic tables in the background (on a separate sheet) and have a "front page" where one selects the language desired and gets the resulting list.
I completely agree but kept them on the same sheet to show the 2 different approaches and leave it to the user to move the components to their own sheets. I also feel when the components are on different sheets it makes it harder for the user to see how they all work together.
- With which I completely agree. My point was that the user, once understanding how it all works together, has "a nicer looking" workbook when "background stuff" is in the background, "foreground" in the foreground. And wanted the user to know that's possible.