Forum Discussion

LauraJackson's avatar
LauraJackson
Copper Contributor
Jun 28, 2023
Solved

Advanced formula related to VLOOKUP

Hi everyone, I'm looking for some help with an advanced formula. I am using VLOOKUP which is populating correctly. However, when it does not find a match, I would like it to pull in a value from ano...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 28, 2023

    LauraJackson 

    That could be

    =IFERROR( VLOOKUP([@[Color]],BH:BP,2,FALSE), $AZ$2 )
LauraJackson's avatar
LauraJackson
Copper Contributor
Jun 28, 2023
That worked perfectly! Thank you Sergei.