thanks for your help, I'll let you know if it works.
--
thanks, idcreek


"Bob Phillips" wrote:

=ISNUMBER(MATCH(A2,Sheet2!F2:F3495,0))

will return TRUE or FALSE


--
HTH

Bob Phillips

"idcreek" wrote in message
...
Thought i knew how to use vlookup. It's been a while since I've used it.
Here's my problem. Got two worksheets, Sheet 1 & Sheet 2. I have catalog
numbers on Sheet 1 in ascending order (column A). I want to see if those
same
numbers are on Sheet 2 (column F). Want the results in column 8 (H) on
Sheet
1. Forumla= (A2,F2-F3495,8,0). I got an N/A in cell H2 and when I copied
the
formula down It had the same thing in all the cells. What am I doing
wrong?

Thanks ahead of time.
--
thanks, idcreek