Thread: Using IF & VLOOKUP together
View Single Post
 
Old 11-17-2010, 05:30 AM
junction junction is offline Windows Vista Office 2003
Novice
  
Join Date: Nov 2010
Posts: 2
junction is on a distinguished road
Default 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
Attached Files
File Type: xls PickList.xls (27.5 KB, 76 views)
File Type: xls StockList.xls (78.0 KB, 80 views)
Last edited by junction; 11-17-2010 at 05:53 AM. Reason: To add documents
Reply With Quote