Following your descriptions, you seem to be using it correctly. Hence,
if you get #N/A it means that the value of A10 is not found in
hopinmas!A:A. Possible reasons:
1. A10 contains a number and the values in hopinmas!A:A *appear* to be
numbers but are actually text, or vice versa. Use the functions
ISTEXT() and ISNUMBER() to see if either is text.
2. If your sku's have dots, or things that might make them look like
decimal numbers, then maybe you have a rounding issue.

In general, try the following formula in a blank cell

=A10=hopinmas!Ax

where you manually find the row x where the same sku value lies as in
A10. If you get FALSE you know something is wrong.
Depending on the reason of discrepancy different things can be
suggested.

HTH
Kostis Vezerides

On Oct 18, 4:24 pm, jerminski73
wrote:
I have tried using the master file both as its own workbook and as a new
sheet in the same workbook as my cheat sheet. I keep getting #N/A as my
result.
This is the function I have defined...
=VLOOKUP(a10,[RShopinmas.xls]hopinmas!$A$2:$S$4500,19,FALSE) seperate workbook
=VLOOKUP(a10,hopinmas!$A$2:$S$4500,19,FALSE)same workbook

a10 is the cell with the SKU on my cheat sheet.
hopinmas!$A$2:$S$4500 is my Inventory master file with column A being SKU
number to match to and column S being the price column I
want to pull pricing from.
19 is in column S
False because I want exact lookups.

Anything obviously wrong?