I have a table with values for each letter and number. I need to lookup Cell A1 and apply values from the table to each number and letter and sum them up
Example1.xlsx
I have a table with values for each letter and number. I need to lookup Cell A1 and apply values from the table to each number and letter and sum them up
Example1.xlsx
Cell C1 formula
Formula:=SUMPRODUCT((ISNUMBER(FIND($F$2:$F$38,A1)))*($F$2:$F$38<>"")*$G$2:$G$38)
Another optionFormula:=LET(m,MID(A1,SEQUENCE(LEN(A1)),1),SUM(XLOOKUP(IFERROR(m+0,m),F2:F38,G2:G38,0,0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks