Replace Text with Abbreviations from Table (need formula)

[saskurja]

I am currently attempting to compile a few columns of data into smaller text (abbreviations). I have two tables, the one I am working from and the one that has the table of abbreviations.
These are the three columns of data that needs to be abbreviated: Criteria 1 Criteria 2 Criteria 3
The table column headers are as follows: Criteria Abbreviation
I have tried adding a column(s) (where I can hide the other 3) to add the abbreviations next to the criteria so the columns can be condensed, but I am struggling with the formula.

Please let me know if you can help. I will be happy to provide more information.

[Melvosh]

It would be very helpful if you could provide a sample workbook, showing an example of the data you're working with, and your desired result (in separate tabs if necessary). You can upload a workbook by clicking Go Advanced, then Manage Attachments. Click Browse to find your workbook, then click Open, and click Upload. Click Close Window, and then submit your reply.

[Keebellah]

HI, welcome to the forum.
Today seems to be the day that questions are asked and the person asking expects the ones reading to understand and see what he/she is trying to explain.
A picture (in this case a file) tells more than a thousand words
Re read your question and try to do as some one that has no idea what it is the file looks like, do you still understand it?
I suggest a sample file (non-private data) with what you have and what you want.
I don't mean to sound 'bitchy' but remember not everyone knows what YOU know so try to bring that accross

[saskurja]

Attached. I put the table (criteria name and abbrv) and then the three columns of criteria that I am needing to replace with abbreviations.

[Melvosh]

Try this in G2 and drag down, see if it's what you're looking for:

Please Login or Register  to view this content.

If that's not what you need, please provide some more detail

[José Augusto]

Try this
In G2 use

Please Login or Register  to view this content.

drag down and forward

[Keebellah]

First your file has outside links which are invalid to my system.
They refer to probably some sharepoint file. All the Data validation links in those three columns don't work here I do get to see a list.

What is the idea you want to do, you replace the text in Criteria 1, 2 and 3 by the abbreviations.
When do you enter the text?
If you have a list of data like column A with the abbreviations next to it you van use VLOOKUP but that cannot be done in the same cell as you type.

What is the procedure you want to use it in? Like I said YOU know what you want but only tells me what you have not how you work with or expect to work with it.
Hope you understand my misunderstanding you question

[Keebellah]

added a sheet that contains the criteria list and the abbreviations.
Two named ranges column A Criteria_List and Column A and B Critreia_Names
In Sheet 1 column a the dropdown list and in column B the vlookup based on the choice in column A
Still do not know how you want to use it

[wyowhite]

In the attached column G has concatenated The criteria - abbreviation of the three columns of criteria.
you could hide the criteria columns to suit your needs
Its all Purple Smoke and Mirrors.

[XLent]

FWIW; should it transpire you want the 1-3 abbreviations concatenated into a single cell (delimited) string and, per your profile, you're using O365 you could use:

Please Login or Register  to view this content.

you could achieve the same type of approach in XL2016 c/o CONCAT