Search, Exact Match - Not sure where the problem is

**ClaireLou1982** · 06-11-2022, 03:00 AM

Hi

I'm trying to pull the name of the person who sent email from a list of sales people.

The problem is that some of the names match actual words (see attached). I think EXACT is what's missing but I can't get it to work...

Can anyone help?

Thanks

**wk9128** · 06-11-2022, 03:18 AM

Cell E7 formula , Drag down

Formula:

Please Login or Register  to view this content.

**Pepe Le Mokko** · 06-11-2022, 03:26 AM

Another way

Search, Exact Match - Not sure where the problem is

LinkBack

Thread Tools

Rate This Thread

Display

Search, Exact Match - Not sure where the problem is

Re: Search, Exact Match - Not sure where the problem is

Re: Search, Exact Match - Not sure where the problem is

Thread Information

Users Browsing this Thread

Similar Threads

How to use INDEX, MATCH, SEARCH to return an exact match for entire cell contents

Excel Formula to Search A for exact match in all rows in A, if match put A in B

Index Match Search Not Using Exact Match

SUMPRODUCT. Exact match VS. Search

[SOLVED] SEARCH and EXACT match

Double Criteria Search - Exact Match on First but Closest Match on Second

Double Criteria Search - Exact Match on First but Closest Match on Second

Bookmarks

Bookmarks

Posting Permissions