lookup_value as array, why lookup over vlookup, multiple lookup_value in single lookup function, sum(lookup) In one of my earlier posts, I had illustrated passing an array for col_index_num in vlookup. Refer Extract and sum vlookup results. We now look at the possibility of passing an array for lookup_value in vlookup. Refer the example below: If we [...]
Posts Tagged ‘lookup’
Lookup_value as array
Posted in Tip, tagged array formula, lookup, sum, vlookup on June 9, 2009 | Leave a Comment »
Text to Numbers
Posted in Just Like That, tagged array formula, code, indirect, Len, lookup, lower, mid, row, Substitute, sum on June 8, 2009 | 1 Comment »
Just like that, each alphabet corresponds to a number, summing up alphabets I cant really see how this post could be useful to you. One of my friends who believed in numerology brought this problem to me of converting names to numbers. Here is the solution that we worked out. You may treat this as [...]
Author
Search blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
Get down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
