You're welcome!

--
Biff
Microsoft Excel MVP


"JockW" wrote in message
...
Thanks to both
--
tia


"T. Valko" wrote:

In workbook1 names on sheet1 in the range A1:An

Workbook2 names on sheet1 in the range A1:A20

Enter this formula on Sheet1 workbook1 cell B1:

=IF(ISNA(MATCH(A1,'[workbook1.xls]Sheet1'!A$1:A$20,0)),"Y","")

Copy down as needed

--
Biff
Microsoft Excel MVP


"JockW" wrote in message
...
Hi guys,
what would be the best way to cross reference a list of names in
workbook1
with a huge list of names in workbook2. Ideally, if a name from w/b1
isn't
found in w/b2, then "Y" to appear next to the name in w/b1.
Any ideas?
--
tia