troubleshooting Question

Excel: Placing Values in One Column Based on Values in Another Column 2--The Sequel

Avatar of apitech
apitech asked on
Microsoft Excel
3 Comments1 Solution366 ViewsLast Modified:

Once again, I need help placing values in one column based on values in another.  Attached is my spreadsheet.  I'm trying to fill in values in column I, based on values in columns B and H.

Specifically, values in column H match those in column B.  For example, cell B8 = "CSIARK".  Cell H8 = "A989".

Since cells D10 through D18 = "CSIARK", cells I10 - I18 therefore need to each contain "A989".

I tried (in cell I2) a formula that was extremely helpful in another case that I was working on.  But, it's not working, here.

Can someone please provide me with the formula that I need?

For future reference, I wish that there were a website or something like that that explains easily how to have Excel fill in values in one cell based on values in another.  I cannot find any.  Surely, I'm not the only one who has this as a very basic business and development need!


IT Director

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros