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!
Is the search range specified large enough? I.e. does it capture the entire range?
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.
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?
Please
[1] Use code tags. Place "[ code ]" before the first line of code and "[/code]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
[3] Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
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)
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks