[newbe]

PROBLEM: When I drag the function down the rows it does not seem to work. I checked the formula and it looks correct on the rows below, but it does not pull the value from the other worksheet at all. I use the $ infrount of the lookup_value. and...

PROBLEM:
When I drag the function down the rows it does not seem to work. I checked the formula and it looks correct on the rows below, but it does not pull the value from the other worksheet at all. I use the $ infrount of the lookup_value. and still this formula is not working! any ideas???

This is what I used.

=VLOOKUP($A2:$A660,'Vendor pricing'!A1:G402,7,FALSE)

I am happy the share the file if you include your email address, but I prefer not to post it online.




BACKGROUND:
I am new to The Whole Vlookup function, and I thought after some practice that I had it down. be it seem I always run into a problem.
I am using Vlookup to extract my cost price from a vendor price list worksheet and pull it over to my control sheet worksheet where I will set my selling price.
I write the function from the tab"insert"> "Function" >Vlookup

I have found the best resource for this is this page:
http://www.timeatlas.com/mos/5_Minut...OKUP_in_Excel/

But it may have left out some important info, but I found it very clear and easy to understand. It did tell me about the Rules & Caveats like = Rule 1 - The left column must contain the values being referenced/ Rule 2 - You can’t have duplicate values/ Rule 3 - When referencing a lookup table, you don’t want your cell references to change when you drag and fill to populate the other cells.


ANY HELP IT MUCH APPRECIATED!!

THANK YOU