Link to home
Start Free TrialLog in
Avatar of apitech
apitech

asked on

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

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
Avatar of santhimurthyd
santhimurthyd
Flag of United States of America image

Avatar of apitech
apitech

ASKER

Whoops!  I thought that I did attach it.  Please take a look and provide formula.

Thanks!

Apitech
3CustomersFilteredNewCustNo.xls
ASKER CERTIFIED SOLUTION
Avatar of JP
JP
Flag of United States of America 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