Thread: vlookup problem
View Single Post
  #1   Report Post  
idcreek
 
Posts: n/a
Default vlookup problem

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