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 look like (result marked in orange).

 

Example:

 

Supplier ABC is situated in C2, I need this to be listed in F4 to match code 12345 and F5 to match code 12341.

 

Thanks in advance.

Formulas & Functions
Need Help

1 Reply

  • 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