Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 01-10-2016, 09:12 AM
jaa522 jaa522 is offline Excel formula that compares thousands of cells between two sheets Windows 10 Excel formula that compares thousands of cells between two sheets Office 2013
Novice
Excel formula that compares thousands of cells between two sheets
 
Join Date: Jan 2016
Posts: 1
jaa522 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Excel Questions.xlsx (491.6 KB, 8 views)
  #2  
Old 01-10-2016, 09:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel formula that compares thousands of cells between two sheets Windows 7 64bit Excel formula that compares thousands of cells between two sheets Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Closed Thread

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 that compares thousands of cells between two sheets 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
Excel formula that compares thousands of cells between two sheets Repeated Cells in different sheets mhdagtas Excel 2 04-27-2011 12:02 AM
Excel formula that compares thousands of cells between two sheets Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft