Hi Maria

Try the below..Adjust the range as required....Please note that this is an
array formula. Within the cell in edit mode (F2) paste this formula and press
Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you
can notice the curly braces at both ends like "{=<formula}"

With your search value in A1 of Sheet1; the below formula will return a
match or no match after checking Sheet2 . Try this formula in B1
=IF(MIN(IF(Sheet2!A1:Z100=A1,COLUMN(A:Z)))0,"Matc h found","No match")


'For an exact match (case sensitive)
=IF(MIN(IF(EXACT(Sheet2!A1:Z100,A1),COLUMN(A:Z))) 0,"Match found","No match")


If this post helps click Yes
---------------
Jacob Skaria


"stuckonexcel" wrote:

Hi

I'm working from Excel mac 2008 and I am trying to create a formula that
allows me to search a name from one spreadsheet, againt the entire contents
of another spreadsheet with the result showing on a seperate spreadsheet (all
within the same workbook)?

I have tried to use Exact, but failed miserably? can anyone help suggest a
way of doing this?

Many thanks

Maria