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...
  • Harun24HR's avatar
    Jan 16, 2024
    Use IFERROR() function in this way =IFERROR(VLOOKUP(....),"")

Resources