Link to home
Start Free TrialLog in
Avatar of joeserrone
joeserrone

asked on

Cell Data based on dropdown using Indirect

I have a spreadsheet similar to the one attached, with two columsn "A" has a Project ID and "B" has the Description of the Project. In cell F6 I created a drop down box based on the Description of Columb B. Once the user selects the right project description I want in Cell G6 to appear the correspondent Project ID. I know I can create this using an Indirect formula, but I am stuck for the correct parameters to use.

P.S. I created a Project ID and ProjectDescription name ranges for each column
Project-List.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of joeserrone
joeserrone

ASKER

Thank you!