• 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


  • 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


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



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)



Excel Ninja
B3, put in formula :

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