| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieve values from 2 worksheets.
Assuming Part Number in column A and Quantity in B on Sheets called WHS1 and
WHS2 then use VLOOKUP on your 3rd sheet: Qty in WHS1 (col B) where A2 is common part number. Copy down as required =VLOOKUP(A2,whs1!$A$1:$B$100,2,FALSE) Qty in WHS2 (col C) =VLOOKUP(A2,whs2!$A$1:$B$100,2,FALSE) Change ranges/sheet names as required. HTH " wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieve values from 2 worksheets.
Thank you Toppers, That does exactly what I need -- ------------------------------------------------------------------------ 's Profile: http://www.excelforum.com/member.php...o&userid=34701 View this thread: http://www.excelforum.com/showthread...hreadid=544707 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieve values from 2 worksheets.
Thanks for the feedback.
" wrote: Thank you Toppers, That does exactly what I need -- ------------------------------------------------------------------------ 's Profile: http://www.excelforum.com/member.php...o&userid=34701 View this thread: http://www.excelforum.com/showthread...hreadid=544707 |
| Reply |
| 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) | |||
Linear Mode
