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:
Hello:

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!

Thanks!

Apitech
ASKER CERTIFIED SOLUTION
JP
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