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.
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
You just need a formula like:
=VLOOKUP(A1,'Other sheet'!A:B,2,FALSE)
You might use a formula like:
=IFERROR(VLOOKUPD2,'Other sheet'!$A$2:$B$1000,2,FALSE),"")
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.
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

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

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.

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.