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.
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.