ok so I figured this much out to go in the Used Column.
=INDEX('Usage Data'!L2:L56, MATCH($A$1 & B3, INDEX('Usage Data'!A2:A56 & 'Usage Data'!B2:B56, 0), 0))
The only thing is, when the $A$1 & B3 don't exist on the Usage Data sheet, I get "N/A" I need that to be "0".
Update, still have the same problem.
New problem the 23000+ items in Inventory are taking WAAAAAAAAY to long to calculate.
Probably going to make each Warehouse it's own workbook.
Still need help with the ="0"
Last edited by fasterthanyours; 07-24-2009 at 11:05 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks