Hi all,

I have an question regarding the look of text in a table. I have periodic texts I want to look up and return a specific value.

I want to look up the following texts:
"Test/ Red 01-2019"
"Test/ Red 02-2019"
"Test/ Blue 01-2019"
"Test/ Blue 02-2019"

In a table that contains 2 columns:
Text --- Value
Test/ Red --- 5
Test/ Yellow --- 7
Test/ Blue --- 9
Test/ Purple --- 11

So "Test/ Red 01-2019" should give me the value 5. Does anyone know if this is possible? I know it is possible to look up "Test/ Red" in "Test/ Red 01-2019", but I want it the other way around.

Is this possible?

Thanks