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

=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

In cell H2, put this formula and copy down as far as you have data in column
A...........

=IF(ISNA(VLOOKUP(A9,Sheet2!$F$2:$F$3495,1,0)),"",V LOOKUP(A9,Sheet2!$F$2:$F$3
495,1,0))

It will return the corresponding value from column A or a blank if it does
not exist in the lookup list.

Vaya con Dios,
Chuck, CABGx3


"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

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


"CLR" wrote:

In cell H2, put this formula and copy down as far as you have data in column
A...........

=IF(ISNA(VLOOKUP(A9,Sheet2!$F$2:$F$3495,1,0)),"",V LOOKUP(A9,Sheet2!$F$2:$F$3
495,1,0))

It will return the corresponding value from column A or a blank if it does
not exist in the lookup list.

Vaya con Dios,
Chuck, CABGx3


"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

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