How to lookup values from different column and return result

[EXCEL2019]

BOTTLE	BOOK	PENCIL	PEN		NAME	RESULT
ABC LIMITED	INC	CORP	ABC LIMITED		ABC LIMITED	BOTTLE
SNC	CORP	XYZ LIMITED	OEM			BOOK
	ABC LIMITED	LIMI	VENDOR			PEN

<tbody>
</tbody>

 

[BlueHornet]

Welcome to the board.

We can't help if we can't see or understand what it is that you're trying to accomplish - and as good as some folks are here, they can't read minds.

What are your criteria for making a lookup? How does that column of "Result" get arrived at? It almost looks like you're trying to find what products ABC LIMITED is associated with, but that's not all that they're listed under, and I'm only guessing. What drives "Result" in this table?

 

[EXCEL2019]

hi BlueHornet,

Sorry, I did not explain properly.

Yes, you are correct. I am trying to find what products are associated with "ABC LIMITED"

The result shows "bottle" "book" and "pen" because those products are associated with ABC limited.
It does not show PENCIL because it is not associated with ABC Limited.
Thank you for your time and help.