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...
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...]
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.