Forum Discussion
BarbaraMiller
Feb 26, 2025Copper Contributor
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)
1 Reply
Sort By
Check out the XLOOKUP function