Excel Multiple Search and return Non Array formula

[Biz]

Hi,
I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E.


Column A Column B Column C Column D Column E

[TABLE="width: 370"]
<tbody>[TR]
[TD="width: 150, bgcolor: transparent"]Name
[/TD]
[TD="width: 82, bgcolor: transparent"]Group Name
[/TD]
[TD="width: 64, bgcolor: transparent"]Should Be
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"]Search For
[/TD]
[TD="width: 64, bgcolor: transparent"]Return Value
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Marvel (V) Ltd
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Tom
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"](V)
[/TD]
[TD="bgcolor: transparent"]Tom
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Dr Strange (V) (C) Ltd
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Tom
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][C]
[/TD]
[TD="bgcolor: transparent"]Harry
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Black Panther [C] (C) Ltd
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Harry
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"](C)
[/TD]
[TD="bgcolor: transparent"]Mary
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Spiderman (C) Ltd
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mary
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

Your help would be greatly appreciated.

Kind Regards

Biz

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...rch-return-non-array-formula.html#post5331763

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).