Forum Discussion

AloysiousB's avatar
AloysiousB
Copper Contributor
Sep 02, 2022
Solved

vlookup and drop down list shows #N/A

So I have been following many different tutorials on using a drop down list and VLOOKUP to return additional data for the drop down item selected. I set up a list of names in the range of C2:C6 for ...
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Sep 02, 2022

    AloysiousB 

    =IFERROR(VLOOKUP(A2,B2:C6,2,False),"")
OR
=IFNA(VLOOKUP(A2,B2:C6,2,False),"")
dscheikey's avatar
dscheikey
Bronze Contributor
Sep 02, 2022

AloysiousB 

=IFERROR(VLOOKUP(A2,B2:C6,2,False),"")
OR
=IFNA(VLOOKUP(A2,B2:C6,2,False),"")
  • AloysiousB's avatar
    AloysiousB
    Copper Contributor
    Sep 02, 2022

    dscheikey 

    The IFERROR line worked perfectly.

     

    Thanks so much

Resources