SOLVED

Autopopulating cells from a dropdown using vlookup function.

Copper Contributor

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

Screenshot 2024-01-16 at 3.25.28 pm.png

 

 

 

 

 

 

 

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?

 

Screenshot 2024-01-16 at 3.22.14 pm.png

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
Use IFERROR() function in this way =IFERROR(VLOOKUP(....),"")
Thanks
That cleared things up for me. Job done.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution
Use IFERROR() function in this way =IFERROR(VLOOKUP(....),"")

View solution in original post