Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another Look up thread...
I receive a weekly Stock Level Report(SLR) at my workplace. This report has data from 7 different warehouses and the rows (and once a month the columns) move around constantly. I created a Date Code report, in which the user enters a SKU and it looks up what the product is, how long its good for, how many cases/pallet, etc. I'm trying to link each SKU on my data list to the Stock level report, to show Weekly sales, and total units. The original plan was to do a simple look up, which worked perfectly... until I got a new SLR, and none of the weekly sales matched up. I have limited knowledge of Excel, and programming in general. Does anyone have any sugestions? -- mbachurski ------------------------------------------------------------------------ mbachurski's Profile: http://www.excelforum.com/member.php...o&userid=30812 View this thread: http://www.excelforum.com/showthread...hreadid=504776 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another Look up thread...
If more than one row in your spreadsheet can have information on a particular product, I think you would be better using sumproduct. If you can be more specific, You will get lots of help. -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=504776 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another Look up thread...
On the User entry sheet, the user will enter one of the Sku's listed in Column 'A' below, and VLOOKUP provides them with the data from columns B through G. (Each warehouse has a separate User entry and Data Sheet). [image: http://i10.photobucket.com/albums/a1...codeData4.jpg] Columns F and G are linked to a constant value in the Weekly SLR I receive (part of which is shown below). So for example, on my Warehouse #1 Data sheet (above), F62, and G62 are linked to K2 and L2 on the sheet below. But as I said in my previous post, the locations change. [image: http://i10.photobucket.com/albums/a1...ecodeSLR2.jpg] So basically I need a way for excel to do a few things. If for example the SKU entered by the user is 4400124, I need it to find that number in column 'B' of my Stock Level Report, and if the Warehouse is Warehouse #1, take the value from Column K and L, and show it in Column F and G of the Data Sheet for the particular warehouse. Hope that makes sense. TIA -M -- mbachurski ------------------------------------------------------------------------ mbachurski's Profile: http://www.excelforum.com/member.php...o&userid=30812 View this thread: http://www.excelforum.com/showthread...hreadid=504776 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another Look up thread...
Does anyone have any ideas or suggestions? -- mbachurski ------------------------------------------------------------------------ mbachurski's Profile: http://www.excelforum.com/member.php...o&userid=30812 View this thread: http://www.excelforum.com/showthread...hreadid=504776 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif question | Excel Worksheet Functions | |||
New problem with new "IF" | Excel Worksheet Functions | |||
Why is eveything so slow after upgrading from Excel 2000 to 2003? | Excel Discussion (Misc queries) | |||
formula in cell not showing result | Excel Worksheet Functions |