Highlight if Data entered appears in another workbook
 

Hi,

I have two workbooks,

When data is entered in one cell of my worksheet I would like excel to check
whether the data entered also appears in a particular column on any sheet in
another workbook.

For example I am entering data on the following spreadsheet called 'log.xls'

A B C D E F
smith 235.03 1293847 ret emelhr
jones 727.90 9938748 snl jtrbhd

When I enter data in column C I would like Excel to go off and see if that
data appears in column F on any worksheet in another workbook 'detail.xls'
and return the value 'True' if it does.

I have tried an ISNUMBER(FIND(() formula but this always returns the Value
false even when I have deliberately duplicated data to try and get a true
value.

Can anybody help?

Thanks
John