If A1 = (Item in Column

[CKlinchock]

Hey guys need some help for a massive matrix I'm putting together at work.


Scenario:
I have a column which contains a list of 300+ unique Titles, the column next to this has the appropriate description of that title and what it does. I have separated the titles and descriptions into it's own sheet for ease of calculating. I want to display the help text/description next to all other instances that title occurs throughout the other sheets of the workbook.

Example:
K4 contains Title 1
K5 contains Title 2
K6 contains Title 3
K7 contains Title 1
K8 contains Title 3
etc etc...

L4 needs to return Title 1 description
L5 needs to return Title 2 description
L6 needs to return Title 3 description
L7 needs to return Title 1 description
L8 needs to return Title 3 description
etc etc...

I hope I painted an appropriate picture of what I'm trying to do. Any and all help is appreciated, none of my logic is working and I'm frustrated for the day, be back at it tomorrow.

Thanks!!
-CK

[xwarlock10x]

can you upload a sample sheet with inputs and expected results ??

[FDibbins]

Hi and welcome to the forum

without seeing a sample of what you are working with, the best I can offer is the suggestion to look into using the =VLOOKUP() function...
=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match
L4=VLOOKUP(K4,sheet1!$A$1:$B$300,2,0)

assuming sheet1!A1:B300 is the range where the descriptions are

[CKlinchock]

As you can see below, I need column 12 to look at column 11's text and if it matches column 14 to pull that particular description from 15. Thanks for the help! I might add that, the attachment below shows the columns have the same text string, IF there is a way to do it using a string contains that would be best because in the export from the system DB I was using the file looks like the 2nd attachment.

Capture.jpg

Capture2.JPG

[CKlinchock]

I couldn't get that to work... Any other suggestions?

[CKlinchock]

Uploaded images.