Solved

# Cell look up

Posted on 2015-02-19
40 Views
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.
0
Question by:Muskett
• 2
• 2
• 2

LVL 85

Accepted Solution

Rory Archibald earned 500 total points
ID: 40618611
You just need a formula like:
=VLOOKUP(A1,'Other sheet'!A:B,2,FALSE)
0

LVL 80

Expert Comment

ID: 40618613
You might use a formula like:
=IFERROR(VLOOKUPD2,'Other sheet'!\$A\$2:\$B\$1000,2,FALSE),"")
0

Author Closing Comment

ID: 40618633
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

LVL 85

Expert Comment

ID: 40618661
Brad's was just missing a parenthesis:

=IFERROR(VLOOKUP(D2,'Other sheet'!\$A\$2:\$B\$1000,2,FALSE),"")
0

LVL 80

Expert Comment

ID: 40618665
Thanks Rory. That's what I get for not testing.

0

Author Comment

ID: 40619025
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

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

#### 747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!