#1
|
|||
|
|||
Excel formula that compares thousands of cells between two sheets
Hello. I have a file that has thousands of inventory and each row is sorted by my item ID (call this file "File1"). I have another file that has the product quantities (call this file "File2"). I want to add a column to File1 that brings in quantities for each item ID that is in File2. If I had the exact same item IDs and order in both files, I would simply do an equals for the quantity cell in File2 and drag it down in File1. However, in File2 the item IDs are not in the same cells (example: item ID 1001 in File1 is in cell A5, but in File2 item ID 1001 is in cell A10). Is there a way that I can create a formula similar to an IF THEN that will check the item ID in column A of File1 and if it equals any item ID in column A of File2, it will put the quantity of that corresponding row into File1?
I know that is hard to explain. Any help is appreciated. I also attached the file; I made one sheet "File1" and one sheet "File2". I highlighted the column in File1 that I made for QTY. I want the corresponding values from column D of File2 to be in that column for QTY in File1. Thanks. |
#2
|
||||
|
||||
Cross posted without links http://www.excelforum.com/excel-gene...wo-sheets.html
Thread closed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
formulas, inventory, product inventory |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying specific cells to a new sheets also give sheetname | dapeamel | Excel | 0 | 02-24-2015 09:20 AM |
Excel Formula: return a range of cells that match | tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
Repeated Cells in different sheets | mhdagtas | Excel | 2 | 04-27-2011 12:02 AM |
Excel 07 formating 17 cells "Need Formula" | Raner | Excel | 2 | 05-30-2010 02:07 PM |