Forum Discussion

La Var Blalock's avatar
La Var Blalock
Copper Contributor
Apr 21, 2020

Nested VLookup Question

I am not sure if this is the right place to ask. But what i am trying to do is this. I have a spreadsheet and i want to do a vlookup and compare 2 data points like email. If it does not match i want to use the second data point  then print out my output.  Does that make sense? The formula what i am using is below but it is Not working so i know i did something wrong.

 

 

=IFERROR(VLOOKUP(D13,$AA$2:$AC$3500,1,FALSE),IFERROR(F13,AA$2:$AC$3500,3,FALSE),"not found")

excel
Formulas and Functions

5 Replies

    • La Var Blalock's avatar
      La Var Blalock
      Copper Contributor
      Apr 21, 2020

      SergeiBaklan 

       

      Yeah I thought that was correct but it I am getting an error you have entered to many arguments for this function 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 21, 2020

        La Var Blalock 

        You missed second VLOOKUP in your formula, it shall be as

        =IFERROR(VLOOKUP(D13,$AA$2:$AC$3500,1,FALSE),
 IFERROR(VLOOKUP(F13,$AA$2:$AC$3500,3,FALSE),
"not found"))

Resources