Forum Discussion

BarbaraMiller's avatar
BarbaraMiller
Copper Contributor
Feb 26, 2025

How to copy information from one file to another based on match of two columns

I am trying to copy information from one file to another based on a match between two different 'columns.

what I want to do is, if the item number matches, show the price in File 2 price column in File 1 price column 

If the item number matches and there is no price in file 2, leave the field blank.

If the item number does not match, leave the field blank.

I am not an excel expert, would not even say I am a intermediate user, but I can learn ๐Ÿ˜ƒ

Does anyone have an idea how to accomplish this? I cannot sort the files, as they are from different systems and not all items are in each one (plus they are HUGE files)

 

 
 
 

Resources