Excel 2007 : Vlookup returning a "0" instead of correct value

[ameyer2307]

I am trying to vlookup an account number on one spreadsheet to my inventory of accounts on another. The formula I am using is =VLOOKUP($B23494,Inventory!$D:$K,6,FALSE) where Column b is the account number, D-K list the account number and vendor information, and column 6 is the Vendor Site Code. This formula has worked for the past 23522 lines but is not picking up the last one I entered. Instead of the correct side code it is giving me a "0." There is data in all of the required columns and I copied what I have as the account number in my spreadsheet into the correct line in the inventory sheet.

Any help would be much appreciated!

[pmalen]

Is the search range specified large enough? I.e. does it capture the entire range?

[ameyer2307]

Yes- The item I need returned is in column "I" and my formula encompasses $D:$K. Like I mentioned before every other line is pulling the correct information. I even entered another inventory item today and that information pulled into my master file perfectly.

[FDibbins]

Does it work if you move that info to a higher row? just as a test to see if it it the data or not?

[OnErrorGoto0]

The only way I can see that you would get a 0 is if the relevant column for that row is blank (or actually contains 0). Are you sure that the information is there and that you do not, for example, have one incomplete row for that account number and a complete one? (a filter on the lookup table may help to check quickly)