comparing columns on 2 different workbooks

**keith6292** · 12-13-2009, 01:46 PM

workbook1 column A has tag numbers, workbook2 column A also has tag numbers. I want to compare the 2 columns and if the tag number in book 1 is also in book 2 i want it to return 25B-F138-28-01 in column B workbook1. thanks for the help. please see my example.

example.xls

**darkyam** · 12-13-2009, 02:23 PM

Something like =IF(ISNUMBER(MATCH(A1,[Workbook2]Sheet1!$A:$A,0)),"25B-F138-28-01","") should work.

**keith6292** · 12-13-2009, 02:47 PM

in that formula after $a:$a what is the ,0 mean?

**darkyam** · 12-13-2009, 02:47 PM

The 0 means the formula looks for an exact match, rather than the closest one without going over.

**keith6292** · 12-13-2009, 02:50 PM

thank you very much. problem solved.

**gneerajg** · 04-11-2010, 04:42 PM

test1 column A has workorderno, test2 column A also has workorderno. I want to compare the 2 columns and if the workorderno in test1 is also in test2 I want it them to in seperate workbook test3 with the corresponding details. I was looking at the formula could not figure out how to modify it. here are the 2 workbooks
thanks in advance

test1.xls

test2.xls