vlookup problem

I

idcreek

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.
 
C

CLR

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)),"",VLOOKUP(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
 
Top