VLookup & Sum function

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Does anyone know if it's possible to have a VLookup do a
summation within the function?

Ex: Vlookup(Acct,Range,Sum(column 2+column 3+ column
4),False)?
Using the data below: Vlookup(1,Range,sum(2+3+4),false)
should = 9


Acct Column2 Column3 Column4
1 3 3 3
2 2 2 2

Thanks!
.....Linda
 
=SUM(VLOOKUP(H1,$A$1:$E$10,{2,3,4,5},0)) array entered will sum the values in
the 2/3/4/5th column where H1 matches the 1st. Make sure to array enter using
CTRL+SHIFT+ENTER

OR

=SUMPRODUCT(VLOOKUP(A11,$A$3:$E$9,{2,3,4,5},0)) will do it without having to
array enter it.
 
Linda

Instead try:

=SUM(OFFSET(B2,MATCH(A1,B2:B6,0)-1,1,1,3))

Range is B2:E6 with acct in column B and A1
holds the value to lookup in B2:B6.
 
Back
Top