Posts: n/a

Comparing Lists

I have this working but I am using two formulas, and want to combine them
into one.

I use =ISNUMBER(MATCH(D3,A$2:A$83,0)) to return a true or false

Then I use this formula to return the text of the cell that is different
=IF(G2=FALSE,D2,"")

How can I combine the two into one formula?

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
Vlookup - Comparing two lists in different worksheets	Lozby	Excel Worksheet Functions	3	August 9th 05 12:14 PM
Comparing two lists in excel that don't match exactly	Tina	Excel Worksheet Functions	2	May 11th 05 05:00 PM
Comparing lists of map references	simonralph	Excel Worksheet Functions	0	April 8th 05 01:18 PM
Comparing multiple lists	Steve	Excel Worksheet Functions	1	March 1st 05 10:06 PM
Comparing 2 Customer Lists to Identify Shared Customers	carl	Excel Worksheet Functions	2	January 26th 05 07:17 PM

All times are GMT +1. The time now is 02:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us