Forum Discussion

Vexum_'s avatar
Vexum_
Copper Contributor
May 12, 2022

Formula with nested IF statements, VLOOKUPs, and IFERROR statements - error message

I am trying to create a price column that will bring in pricing information from a price sheet. There are six different vendors (I am creating one IF statement for each vendor) and the correct value ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 12, 2022

Vexum_ 

I guess it's like

=
IF( [@Vendor] = "Vendor1",
    IFERROR(VLOOKUP([@ModelFamily],'[pricesheet.xlsx]PriceList'!$D:$X,21,FALSE),
    IFERROR(VLOOKUP([@ModelFamily],'[pricesheet.xlsx]PriceList'!$E:$X,20,FALSE),
    VLOOKUP([@ModelFamily],'[Bulk - Master Tracker.xlsx]PriceList'!$C:$X,22, FALSE))),
IF( [@Vendor] = "Vendor2",
    IFERROR(VLOOKUP([@ModelFamily],'[pricesheet.xlsx]PriceList'!$D:$Y,22,FALSE),
    IFERROR(VLOOKUP([@ModelFamily],'[pricesheet.xlsx]PriceList'!$E:$Y,21,FALSE),
    VLOOKUP([@ModelFamily],'pricesheet.xlsx]PriceList'!$C:$Y,23, FALSE))) ))

Resources