0

What I mean is, if I have:

f1.xls

Product ID / Product Name 
1          / 12    
2          / 13,64

f2.xls

Name_ID / Name_Val    
12      / aaa    
13      / bbb    
64      / ccc

Can I somehow merge them to: 

Product ID / Product Name    
1          / aaa    
2          / bbb    / ccc    
?
pnuts
  • 58,317
  • 11
  • 87
  • 139
Slava Zoref
  • 305
  • 2
  • 5
  • 16
  • Look at the [VLOOKUP function](https://support.office.com/en-us/article/vlookup-function-adceda66-30de-4f26-923b-7257939faa65) and [INDEX](https://support.office.com/en-us/article/index-function-0ee99cef-a811-4762-8cfb-a222dd31368a)/[MATCH](https://support.office.com/en-us/article/match-function-0600e189-9f3c-4e4f-98c1-943a0eb427ca) functions. –  Jun 03 '15 at 10:40

1 Answers1

0

If you have several values in one cell separated by a comma, as your "Product name" data sample suggests, it will be very difficult to process with a formula. You will need to provide more than just a data sample like the above.

It also looks like you expect several values as output in one cell. Again, this is not easily accomplished.

I suggest that you step back from constructing hypothetical solutions that are based on assumptions that may or may not be met by Excel.

Instead, please explain the bigger picture. What are you trying to achieve? That is not "Merge the two files". What is the reason that makes you want to merge the files?

My answer will probably be shot down because I'm only asking questions for clarification and not providing a 'real' answer, but in order to even get started on your question, you need to provide a lot more background and I did not want to do this with comments.

Post more detail about your real situation. Post the bigger picture. Edit your question and provide that detail.

teylyn
  • 34,374
  • 4
  • 53
  • 73