Hello All,
I am trying to develop a Workbook (see attached) and I will be working, for the most part with alpha data.
On Sheet one, I listed (what I believe to be coins and paper money that may have value larger than the face value. Sheet two is the Glossery of Terms pertaining to coins.
What I need to do is show the respective Term(s) with each coin. But, what I can not accomplish is multiple Terms pertaining to any given coin in the same column separated by a comma.
If I do an =sign and click on the Term that applies, it works great, but if I try to reference an additional term that applies it either returns a 0, true,#Ref! plus several more no matter how I try to write a formula, VLookup doesn't seem work either
I don't have much experience with Excel, so I am at a loss how to get this done Mind you, there will be additional sheets I will add and I will also need to do the same function.
Thanks in advance for any help you can offer!