Forum Discussion

gdubey's avatar
gdubey
Copper Contributor
Jun 29, 2020
Solved

Excel help with vlookup and more

Hello, I am trying to create an order form in Excel with 5 columns. First 2 columns are generic Item No. and Quantity. My 3rd Col. has Vendor information where a person can pick the vendor they want ...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 29, 2020

    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_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 29, 2020

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's avatar
gdubey
Copper Contributor
Jun 29, 2020

Riny_van_Eekelen 

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.

Resources