Forum Discussion
Solved
lookup to array in one cell
hi, i have a array in one cell, like this: dog,cat,fish and i have a table of prices, like this: dog - 1 cat - 2 fish -3 i want to get a formula that sum all the array, 1+2+3=6. i c...
Who ever produced this data should be hit with the workbook.
=SUM(XLOOKUP(FILTERXML("<y><z>"&SUBSTITUTE(A1,",","</z><z>")&"</z></y>","//z"),$E$1:$E$3,$F$1:$F$3))Detlef_Lewin hi,
its work excellent with Excel. but i need use it with Excel online, and the function 'FILTERXML' dosent work there. can u help my again? sorry.... ty
- ty. u help my so much!!
- in your data the array write in the next lows (by <z>),
how can i write it in the next column? (by <?>)? ty
[i ask because i have a table, and your data dosen work...]It's not my data, it's your data.
And if you think the formula does not work then please provide a sample workbook.
ty!! king!!
