Hi,
this is the sheet (A1="name"; A2="A ltd"; ... ; B1="jan"; ... ... ...):

name jan feb
Altd 5 8
Bltd 10 9
Cltd 7 11

In cells AA21 this formula (9 the result) VLOOKUP(A20,A1:C4,3,FALSE)) where
AA20 = "Bltd".

Now the problem: how can put in AA22 the SUM of "name" using VLOOKUP? (no
code VBA)

Example: if AA20 ="B ltd" the AA22 will be the sum of 10 and 9 = 19

Thanks in advance
M.