Vlookup Ref error

I am just getting into Excel programming.

I've attached my two sheet workbook with a sample. The first sheet (MBIR-Nov) has the cell with the vlookup error in it. The second sheet holds the data I'm trying to get the first sheet to reference.

And if you want to take it a step further, what I'm REALLY trying to do is the following:

Divide the number of complaints by the total number of products shipped for that month to find the percentage of "problem products". I want to do this by dividing the value in the cell directly above the vlookup-error-cell by the value derived from the VLookup, which needs to check both month AND year (currently only looking at month) so that I end up with a percentage.

Am I crazy or is this do-able?

Thanks for your tip. I changed my range from the B column only to include cells A1:H120. When I made that change, I noticed that now my error is an "N/A" error instead of a "Ref" error.

Any ideas on what I need to do now?

Thanks - that fixed my first problem.

Now how do I make it able to look up the year, then the month, then return the result into the field?

You're now looking in column A of the second sheet for the month number (which is in column B). Based on what you said you are looking for (yr and month) I suggest you combine columns A and B in PackNum (I did it with a space between year and month) and then you can concatenate your year and month in your lookup with this formula

Please Login or Register  to view this content.

I attached your modified workbook.

ChemistB