Best compare technique, exact, vlookup? What do I need?

[firestart]

Hi,

I am trying to compare a list with a list in another document. What I need to do is:

1. look at each cell in sheet 1

2. compare that 1 cell from sheet 1 with every cell in sheet 2, or at least a range of cells

3. Indicate by colour or 'true' 'false' that the alpha numeric data in sheet 1 has been found in sheet 2

I have tried =OR(EXACT(B5,Sheet1!E2:E29))

This doesn't always work, and it never works when the range is E:E

Also tried =IF(J24=VLOOKUP(J24,K24,1),"Yes","No")


Can anyone give help, and what am I doing wrong?

[Ron Coderre]

Maybe this could work for you:

B1: =SUMPRODUCT(--(Sheet2!$A$1:$D$15=Sheet1!A1))>=1

That formula in B1 on Sheet1 tests if Cell A1 on Sheet1 is found anywhere in the range $A$1:$D$15 on Sheet2. If yes, then TRUE, otherwise FALSE.

Is that something you can work with?

Ron