• 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

@Gopigk

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

  • Test File.xlsx
    9.5 KB · Views: 9
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
 
B3, put in formula :

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

72739
 
You must log in or register to reply here.
Back
Top