Return a value Yes or No if data match

**Mys228** · 08-23-2014, 10:46 PM

Someone please help! I try to match 5 local zip codes to a column that contain local and out of state zip code and return a value "Yes" if it match and/or "No" of not match.

for example, i try to match D32:D65479 to M5:M10:

column M5:M10
9xxxx
9xxxx
9xxxx
9xxxx
9xxxx

Column D32:D65479
xxxx
xxxx
xxxx
xxxx

thanks.

**Ron Coderre** · 08-23-2014, 11:08 PM

Using your described scenario...Try this regular formula, copied down as far as you need:

Please Login or Register  to view this content.

Is that something you can work with?

**Mys228** · 08-23-2014, 11:45 PM

Ron,

it works wonderful.

thank you.

Return a value Yes or No if data match

LinkBack

Thread Tools

Rate This Thread

Display

Return a value Yes or No if data match

Re: Return a value Yes or No if data match

Re: Return a value Yes or No if data match

Thread Information

Users Browsing this Thread

Similar Threads

Return a value Yes or No if data match

[SOLVED] Need to Match 2 pieces of data and return a third

2010 - Need to match data and return specific cell value - SUMIF? MATCH? INDEX? HELP!

[SOLVED] Two Excel sheets trying to match text data and return the match from the second column!

[SOLVED] Please help: Want to match data and return a different cell

Bookmarks

Bookmarks

Posting Permissions