| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve values from 2 worksheets.
I have 2 worksheets with part numbers and quantities in stock for 2 separate warehouses. I have a 3rd sheet with commonly used parts on. For the commonly used part Nos, I want to get the quantity in stock for each Warehouse. i.e. PART NUMBER WAREHOUSE 1 STOCK WAREHOUSE 2 STOCK abc43 55 23 qwe21 35 87 fde182 12 14 I can see on the preview that my table above looks rubbish! Hopefully you can see what I mean? Part# abc43 - Warehouse 1 stock 55, Warehouse 2 stock 23 I have spent several hours looking through the various functions with no luck. Any help greatly appreciated. -- ------------------------------------------------------------------------ 's Profile: http://www.excelforum.com/member.php...o&userid=34701 View this thread: http://www.excelforum.com/showthread...hreadid=544707 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Adding values from several worksheets - would appreciate the help | Excel Worksheet Functions | |||
| How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
