VLOOKUP - Return multiple values vertically based on 2 drop down list.

[RahulNa]

Hi Guys,

I hope all of you are safe and doing good.

I have an excel which has 2 drop-down lists "Sales Person Name" and "Sales Type (Existing & New)" based on the above I want to display their Unique account name.

Please share any formula or view to help me with this. Also, don't require VBA for the same as the file will be kept at a SharePoint where it might not work.

 

[RahulNa]

In that case can you please use the XL2BB add-in to post your data (including formula) to the thread.

Hi,

In one of the sheets, I have a master mapping file like below. and in another sheet, I have data validation where I want to display the value.

Owner	Type	Account Name
Alpha	EM	ABSA
Alpha	EM	ABSA
Alpha	EM	FNB
Alpha	EM	FNB
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank

 

[RahulNa]

Hi,

The below is a sample data which is in one worksheet and the view and data validation are in different sheet.

Owner	Type	Account Name
Alpha	EM	ABSA
Alpha	EM	ABSA
Alpha	EM	FNB
Alpha	EM	FNB
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank
Alpha	EM	Standard Bank

 

[Fluff]

In future please use the XL2BB add-in, as that shows what formulae are being used & what the ranges are.
That said, how about
=UNIQUE(FILTER(C2:C13,(A2:A13=E2)*(B2:B13=F2)))

 

[RahulNa]

In that case can you please use the XL2BB add-in to post your data (including formula) to the thread.

Thank you for guiding on the right thing and solving the problem,

 

[Fluff]

You're welcome & thanks for the feedback