• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 47
  • Last Modified:

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.
0
Muskett
Asked:
Muskett
  • 2
  • 2
  • 2
1 Solution
 
Rory ArchibaldCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now