Cell look up

I have a sheet that contains project numbers (column A) and descriptions in column B.
In another sheet I have created a dropdown box that has all the project numbers. I want the adjacent column to fill in the description depending on the project number selected.
MuskettAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
You just need a formula like:
=VLOOKUP(A1,'Other sheet'!A:B,2,FALSE)
0
 
byundtCommented:
You might use a formula like:
=IFERROR(VLOOKUPD2,'Other sheet'!$A$2:$B$1000,2,FALSE),"")
0
 
MuskettAuthor Commented:
Great response, exactly what I was trying to figure out. Sorry to the other reply which I like as it gets rid of errors but I cannot get it to run.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Rory ArchibaldCommented:
Brad's was just missing a parenthesis:

=IFERROR(VLOOKUP(D2,'Other sheet'!$A$2:$B$1000,2,FALSE),"")
0
 
byundtCommented:
Thanks Rory. That's what I get for not testing.

Brad
0
 
MuskettAuthor Commented:
Hi Brad,
I cannot change the points but big thanks anyway.
Actually the  formula should be:
=IFERROR(VLOOKUP(A1,'Other sheet'!$A$2:$B$1000,2,FALSE),"")
I have tested and it works perfectly.

Thanks
Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.