i have a problem and i hope you can help me...

i'm building a spreadsheet where there is a list where users will input work shifts (those shift names can be, for example, "M", "N", "T", "Me", "Te", "Ne"...

i have two different tables, one for getting values for the shifts "M", "N" and "T", the other for getting the values for the shifts "Me", "Ne" and "Te".

the values are count in separate columns through vlookup functions.

is there a simple way to get the values if, for example, a user needs to input two shifts in the same day?

theorically the user can input any two shifts to a maximum of 3 shifts in a day

if "MT", then i want to sum the value of vlookup "M" + value of vlookup "T"

if "MeT", then i want to get the value of vlookp "Me" in a column and the value of vlookup "T" in another column. the values of "Me" and "T" cannot be summed.