google spreadsheet - Replace several parts of a string with values from a lookup table -
i have cell text: "aaa,bbb,ccc,ddd,eee".
i have lookup table values corresponding different strings. e.g. "aaa"=1, "bbb"=2 etc.
i need create single cell text "aaa" etc. have been replaces corresponding value.
e.g. string "aaa,bbb" should create string "1,2".
any way this?
if lookup table in columns a:b , text want replace in cell c1 try:
=join(",",arrayformula(vlookup(split(c1,","),a:b,2,0)))
Comments
Post a Comment