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
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
Whoops! I thought that I did attach it. Please take a look and provide formula.
Thanks!
Apitech
3CustomersFilteredNewCustNo.xls
Thanks!
Apitech
3CustomersFilteredNewCustNo.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check below links for the formula reference with samples
http://www.dur.ac.uk/resources/its/info/guides/35Excel2003Formulae.pdf
http://www.csu.edu.au/division/dit/staff/training/microsoft/office-2007/excel/docs/advanced-formulas-functions.pdf
http://free-pdf-ebook.com/2010/02/06/excel-2007-formulas-function/