Forum Discussion
How to create a look-up form
I want to set up a pricing chart where I input all the numbers into one sheet, and then I use dropdowns in another sheet to spit out the numbers I'm looking for from the first sheet. So like, say...
tiggert45 In the attached workbook, I show a few options and include URLs to documentation and articles. The _Info worksheet contains details.
(Excel 2021 or a later version is needed because of use of the UNIQUE function. I don't believe Excel 365 or Excel for the web is required, but it might be useful.)