Another Combining Columns Question

[bushwacked]

Hello!

I have 2 sets of data, with the same Constant ID in each (Customer Name) I am looking to join these 2 lists together and add the new numbers to the 3rd column basically like below. Googled around but not sure what type of formula/function I could use to join these 2 lists.

If it matters, the lists do not match 1:1 at the row level ... So customer on line 4 might be Customer on line 7 for the 2nd list. However, same name, but list 2 might just have more customers on it ...

111.png


Thanks for any help on this!

[TMS]

You could use VLOOKUP, XLOOKUP, INDEX/MATCH or even FILTER. For example, C2 copied down:

Please Login or Register  to view this content.

[bushwacked]

Perfect, thank you!! Not sure why I thought vlookup would not handle this

[TMS]

You're welcome.



You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[bushwacked]

was not aware, but now I am and also done

[TMS]

You're welcome. Thanks for the rep.