In your new master workbook, in column B, put:
=IF(ISNA(VLOOKUP(A1,[OldMasterWkBk.xls]Sheet1!$A$1:$A$13,1)),"notexist","exists")
(i.e., if VLOOKUP fails to find a value, #NA is true)
"billbeecham" wrote:
Hello all,
I have a slight problem that I just can't seem to figure out how to
accomplish.
I have two excel sheets, one is a new master and the other is old
master
The new and old master sheets contain mostly the same data but not in
the same order.
I am trying to simply compare cell A1 of newmaster to all 13 cells in
old master looking for a match and making a note in newmaster column B
of the same row that says either "exists" or "notexist"
So like, if my sheets looked like the following:
NEWMASTER......................................... ...................OLDMASTER
A1
pokemon.jpg....................................... ..................A1
beyblades.jpg
A2
halo.jpg.......................................... .......................A2
pokemon.jpg
A3
bleach.jpg........................................ .....................A3
onepiece.jpg
A4
beyblades.jpg..................................... ..................A4
sailormoon.jpg
I would be left with my newmaster looking like the following:
NEWMASTER
A1 pokemon.jpg..........B1 exists
A2 halo.jpg..................B2 notexist
A3 bleach.jpg...............B3 notexist
A4 beyblades.jpg.........B4 exists
I hope I have explained this well. I have included two files that
represent a teeny snippet of the actual data.
I have tried to do this myself for several days now by taking bits from
a bunch of macros but I am not getting anywhere.
I can compare as if they both had to be in same order, but not with
them out of order.
Thanks in advance for any help I can get on this!
Bill Beecham
+-------------------------------------------------------------------+
|Filename: oldmaster.txt |
|Download: http://www.excelforum.com/attachment.php?postid=3736 |
+-------------------------------------------------------------------+
--
billbeecham
------------------------------------------------------------------------
billbeecham's Profile: http://www.excelforum.com/member.php...o&userid=16286
View this thread: http://www.excelforum.com/showthread...hreadid=398686