Posted to microsoft.public.excel.worksheet.functions

gootroots

external usenet poster

Posts: 28

Return match result

example:

book1 sheet1 contains non duplicate values in A1:A10

book2 sheet1 contains non duplicate values in A1:A10

I need a formula to reurn "record matched" or "record not matched" in book2
sheet1 in B1:B10

thank you if you can be of help!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula result does not match displayed result	lothar	Excel Worksheet Functions	1	June 23rd 08 05:05 AM
excel result return wrong calcuation result	garyww	Excel Worksheet Functions	1	August 14th 06 11:14 AM
excel result return wrong calcuation result	garyww	Excel Worksheet Functions	0	August 14th 06 05:02 AM
excel result return wrong calcuation result	garyww	Excel Worksheet Functions	0	August 14th 06 05:02 AM
Advanced formula - Return result & Show Cell Reference of result	Irv	Excel Worksheet Functions	7	May 6th 06 03:36 AM

All times are GMT +1. The time now is 07:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us