|
|
#1
11-17-2010, 05:30 AM
|
|||
|
|||
Using IF & VLOOKUP together
I'm posting on here as a last resort, basically I've given up and hope someone can help!
I have 2 spreadsheets, one is a stock list (StockList.xls) and the other is a pick list (PickList.xls) I need the Code_EAN (Column F) in StockList.xls to look at the Barcode (Column D) in PickList.xls IF the Code_EAN is the same as the Barcode then the QTY PICKED (Column G) in PickList.xls is inserted into Amount Picked (Column H) in StockList.xls, this will then amend the Amount Remaining field. If anyone can help with this it would be greatly appreciated  Last edited by junction; 11-17-2010 at 05:53 AM. Reason: To add documents 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
| Vlookup Examples Please ????? | AmrMahmoud1982 | Excel | 2 | 10-10-2010 06:31 PM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
 Is this possible using the Vlookup or any other function?
|
Delson | Excel | 4 | 02-08-2010 01:27 PM |
| vlookup question | Tony G | Excel | 9 | 03-28-2009 11:16 PM |
Windows Vista 
Office 2003
Threaded Mode