Hi
Many thanks for taking the trouble to read this Thread.I’ve tried searching the forum for a similar problem / question, but to no avail,hence the new Thread.
I have a row of values (A5:A9, shownin black) I want to look-up (using VLOOKUP) in a small table (A1:B3, shown in red) and then sum thesefigures at the bottom of the table in cell B14 (shown in green).
<tbody>
</tbody>
Iappreciate I can do this using VLOOKUP in each of the cells adjoining the A5:A9 range then total with a SUM, whatI was wondering however was, is it possible to use VLOOKUP in an array formula? I tried using the following formula: {=SUM(VLOOKUP(A5:A9,$A$1:$B$3,2,TRUE)}which seems to sum the first value only.
I’mstill on the ‘array formula’ learning curve, and was hoping someone could pointout where my mistake is and / or whether what I’m trying to achieve is possiblewith array formulae?
Manythanks,
2016LM
Many thanks for taking the trouble to read this Thread.I’ve tried searching the forum for a similar problem / question, but to no avail,hence the new Thread.
I have a row of values (A5:A9, shownin black) I want to look-up (using VLOOKUP) in a small table (A1:B3, shown in red) and then sum thesefigures at the bottom of the table in cell B14 (shown in green).
1 | 7 |
2 | 10 |
3 | 12 |
1 | 7 |
1 | 7 |
3 | 12 |
3 | 12 |
2 | 10 |
TOTAL | 46 |
<tbody>
</tbody>
Iappreciate I can do this using VLOOKUP in each of the cells adjoining the A5:A9 range then total with a SUM, whatI was wondering however was, is it possible to use VLOOKUP in an array formula? I tried using the following formula: {=SUM(VLOOKUP(A5:A9,$A$1:$B$3,2,TRUE)}which seems to sum the first value only.
I’mstill on the ‘array formula’ learning curve, and was hoping someone could pointout where my mistake is and / or whether what I’m trying to achieve is possiblewith array formulae?
Manythanks,
2016LM
Last edited: