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 )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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.
    • LauraJackson's avatar
      LauraJackson
      Copper Contributor
      Jun 30, 2023
      HI Sergei, a follow up question if you don't mind.
      I tried auto fill to bring this formula down to each cell in the column. However I noticed it is keeping $AP$2 for every line. Is there a way to auto fill this down to the other cells but have it auto adjust the formula to $AP$3, $AP$4, etc?
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jun 30, 2023

        LauraJackson 

        Yes, please use relative reference $AP2 (instead of $AP$2) and drag formula down.

Resources