I have a summary sheet for all styles of our product sold
to one company, and the actual monthly sales for each
product on separate monthly worksheets (gotten from
Access). The monthlies only have the products that actually
sold, not the full list of products listed on the summary page.
So I wrote a LOOKUP for the summary page to go to the
monthly, look for a match on the part number, and return
the quantity sold.
First one correctly returned a #N/A - good. I autofilled
the rest down. And got a #N/A for the second one, and then
the quantity of 1 for absolutely everything else. Only 6
products sold, though they all had a quantity of 1.

The formula
=LOOKUP($A4,'Jul 03'!$B$2:$B$50,'Jul 03'!$A$2:$A$50)
looks correct to me. I used 50 in my formula even though
there's only 7 rows in this particular sheet, so I could
copy it to all other columns without adjusting more than
the sheet name.
=LOOKUP($A6,'Jul 03'!$B$2:$B$50,'Jul 03'!$A$2:$A$50)
is where I start getting a return value of 1 for everything.

I cannot see the problem - help help!