How to lookup values from different column and return result

[EXCEL2019]

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]BOTTLE[/TD]
[TD]BOOK[/TD]
[TD]PENCIL[/TD]
[TD]PEN[/TD]
[TD][/TD]
[TD]NAME[/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]ABC LIMITED[/TD]
[TD]INC
[/TD]
[TD]CORP[/TD]
[TD]ABC LIMITED[/TD]
[TD][/TD]
[TD]ABC LIMITED[/TD]
[TD]BOTTLE[/TD]
[/TR]
[TR]
[TD]SNC[/TD]
[TD]CORP[/TD]
[TD]XYZ LIMITED[/TD]
[TD]OEM[/TD]
[TD][/TD]
[TD][/TD]
[TD]BOOK[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ABC LIMITED[/TD]
[TD]LIMI[/TD]
[TD]VENDOR[/TD]
[TD][/TD]
[TD][/TD]
[TD]PEN[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.