Hello,
I am trying to sum multiple lookups in a table but just cant get it. Here is my table:
<colgroup><col width="64" style="width: 48pt;" span="2">
<tbody>
</tbody>
147
So if lookup 147 I want the return to be 11000100.
This is what I was trying =SUM(VLOOKUP(SEARCH(A1:A8,A10),A1:B8,2,))
Thank you in advance.
I am trying to sum multiple lookups in a table but just cant get it. Here is my table:
1 | 100000 |
2 | 10000 |
3 | 1000 |
4 | 100 |
5 | 10 |
6 | 1 |
7 | 1000000 |
D | 1111111 |
147
So if lookup 147 I want the return to be 11000100.
This is what I was trying =SUM(VLOOKUP(SEARCH(A1:A8,A10),A1:B8,2,))
Thank you in advance.