Forum Discussion

christian galea's avatar
christian galea
Copper Contributor
Jan 18, 2018

Excel formula question

Hi.   I need a formula that helps me list supplier name situated in column C under column F against codes listed in column A. I am attaching a "Test" excel sheet of what the final result needs to...
Formulas & Functions
Need Help
Kevin Lehrbass's avatar
Kevin Lehrbass
Brass Contributor
Jan 18, 2018

Hi Christian,

 

I have a solution for you.

In cell G2 add this formula and drag it down:   =IF(LEFT($C2,8)="Supplier",C2,G1)

In cell H2 add this formula and drag it down:  =IF(ISNUMBER(A2),G2,"")

Note that depending on your region the comma in the formula might need to be a semi colon.

 

Cheers,

Kevin

http://www.myspreadsheetlab.com/blog/

Resources