Forum Discussion
Excel help with vlookup and more
gdubey Attached. workbook with two possible solutions.
The first uses named ranges and INDIRECT. In the attached example the named ranges are static. Didn't go so far as to make them (more) dynamic since you indicated that you had everything working except for the part number lookup.
The second one uses new functions (UNIQUE, FILTER, XLOOKUP) and only works on the most recent version of Excel.
gdubey Attached. workbook with two possible solutions.
The first uses named ranges and INDIRECT. In the attached example the named ranges are static. Didn't go so far as to make them (more) dynamic since you indicated that you had everything working except for the part number lookup.
The second one uses new functions (UNIQUE, FILTER, XLOOKUP) and only works on the most recent version of Excel.
Riny_van_Eekelenman, you are the master...you have solved my issue. I really want to thank you for your suggestion and attaching this file for me. it gave me god idea what I need to do. much, much appreciated...keep up the good work 🙂
gdubey Glad you could figure it out before I had a chance to respond to your previous post. In case you are using Microsoft365 (previously known as Office365), you may find the second solution more flexible, though. The functions used should become available to most subscribers in the coming weeks.
Imagine you have hundreds of vendors and thousands of parts. Working with named ranges will soon become difficult, if not unmanageable. The second option allows you to put all the vendor and parts information in one big table, and run dynamic valuation lists from that.
Riny_van_Eekelen thank you for all the information. Of course, people were impressed when I showed them what I am working on....I was asked to add one more column in this form that can show current pricing information for the products. Example-Select->Vendor->Product->PN pop ups and than pricing pop up column. Is this something I can do easily do I have edit your great formula?
since, I am horrible with Excel, I am trying to understand your response and data/form you sent to me. Thank you again
I am attaching my form in this well for you to take a look...
as you can see, if you select CISCO for vendor, select any hardware they sell, you will see the part no will change accordingly. BUT, it only works with CISCO!!! if I select different vendor, it doesn't work.
I haven't check your solution yet just got busy with work but I will check it out and let you know. I much appreciated your help and your quick reply.
