• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula required for list of multiple Text values

@Gopigk

New Member
Hi all

I have excel data contains the list of vendor names, grouped under a different category. I want a formula, that if I entered the Vendor name in one column, need to fill the department name in the side column against it.
Herewith I attached a sample excel file with 2 sheets (Vendor names & daily data). In sheet daily data, If I enter the vendor name in cell A3, need to auto fill the department name in cell B3, and so on.

Request help in this regard
 

Attachments

saurabhjaina211

New Member
Hi Gopigk,

put below formula in cell B3:

=IF(ISNA(VLOOKUP($A$3,'Vendor Names'!$A:$A,1,0)),IF(ISNA(VLOOKUP($A$3,'Vendor Names'!$B:$B,1,0)),IF(ISNA(VLOOKUP($A$3,'Vendor Names'!$C:$C,1,0)),"Not Exist",'Vendor Names'!$C$1),'Vendor Names'!$B$1),'Vendor Names'!$A$1)

Thanks,
Saurabh
 

bosco_yip

Excel Ninja
B3, put in formula :

=INDEX('Vendor Names'!A1:C1,SUMPRODUCT(('Vendor Names'!A3:C7=A3)*COLUMN('Vendor Names'!A1:C1)))

72739
 
Top