=MATCH(B3,'ACTIVE COMM CUSTOMERS'!$A:$A,0)

this may seem really basic, but i did the same thing and it worked great

In an active worksheet, I ran a column next to the data I was comparing (B3)
in this case. Then in MATCH, used the array from a different worksheet, and
the column A. After dragging the formula down the entire B column (30000
rows), I sorted. Two results. If there was a MATCH, it gave me the LOCATION
of the matching field, and if there was no match, I knew I was missing data
from the other worksheet. Hope this helps.. it's really easy and you can do
it on the fly without using VLOOKUP






"Daniel" wrote:

Hi. i have a workbook with multiple worksheets and some of them contain
matching data. say, i have worksheet A where i have numbers in column 1, and
i have worksheet B where i have numbers in column 1 (some of them matching
the ones in worksheet A), and have Comments in column 2. i want to pull up
the comments in worksheet A where column 1 has matching data to worksheet B
column 1. i tried a simple Vlookup but i always get N/A. hope this makes
sense. any suggestions?