Forum Discussion

Philysgdy's avatar
Philysgdy
Copper Contributor
Jan 16, 2024
Solved

Autopopulating cells from a dropdown using vlookup function.

I have a dropdown list which I have gathered from a table.

 

 

 

 

 

 

 

When I put in a Vlookup function to autopopulate adjacent cells it creates a #N/A when have not selected a value. How do I overcome this?

 

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Use IFERROR() function in this way =IFERROR(VLOOKUP(....),"")
    • Philysgdy's avatar
      Philysgdy
      Copper Contributor
      Thanks
      That cleared things up for me. Job done.

Resources