Forum Discussion
Philysgdy
Jan 16, 2024Copper Contributor
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?
- Use IFERROR() function in this way =IFERROR(VLOOKUP(....),"")