Forum Discussion

kareemshamel77's avatar
kareemshamel77
Copper Contributor
Mar 01, 2023

How to match two columns that have common values together

Greetings Comm!

 

I have a case where I have a common number between 2 columns in a sheet and I want to link them together, so as shown below for example FileX 231 in column A to be in front of 231 in column B.

 

Any idea how to reach this?

I would be very grateful for any assistance!

 

excel
Formulas and Functions

2 Replies

Sort By
  • ricardojose's avatar
    ricardojose
    Brass Contributor
    Mar 01, 2023
    I think you need to combine two formulas: MID and FILTER there. But, if you upload that file with one tab with your problem... And in another tab, you put the solution manually. I can produce the solution using formulas and share that with you
    • kareemshamel77's avatar
      kareemshamel77
      Copper Contributor
      Mar 06, 2023

      ricardojose Hello, here's the link for the sample file I made:

       

      https://1drv.ms/x/s!Alq4caKydpVMoFU76XFRX8vOwmzw

       

      Appreciating your help!

Resources