vlookup question?

[coltheplumb]

hi ho u bright lot , ok here is my thing.. i want to add up 3 cells and include the answer into a vlookup ? can this be done , I dont want to put the total of the 3 cells into a seperate cell so that it would work on an ordinary vlookup. so what im after is say ...
=sum(a1+a2+a3),vlookup(??,c6:d12,2). ....is this possible ??
thanks for any help that comes forward
Colin X

 

[Aladin Akyurek]

hi ho u bright lot , ok here is my thing.. i want to add up 3 cells and include the answer into a vlookup ? can this be done , I dont want to put the total of the 3 cells into a seperate cell so that it would work on an ordinary vlookup. so what im after is say ...
=sum(a1+a2+a3),vlookup(??,c6:d12,2). ....is this possible ??
thanks for any help that comes forward
Colin X

Are you after this...

=VLOOKUP(SUM(A1:A3),C6:D12,2,...)

 

[Marcelo Branco]

Maybe (if i understood correctly...)

=VLOOKUP(A1+A2+A3,C6:D12,2)

HTH

M.

 

[coltheplumb]

well done guys , once again you come up trumps
Cheers again
Colin X

 

[coltheplumb]

OK that works great, now ( and sorry to be a pain) is there a way i can get it to show 0 if say 2or 1 of the three cells have nothing entered in them ? rather than it showing a N/A ?.
Cheers again
Colin X

 

[Marcelo Branco]

Try

=IF(COUNT(A1:A3)=3,VLOOKUP(SUM(A1:A3),C6:D12,2),0)

M.

 

[Marcelo Branco]

Complementing my previous post

With my last formula is still possible to have a #N/A result if the result of Sum(A1:A3) is not found in the range C6:C12

M.

 

[coltheplumb]

he he he sooooooooooo good thanks ever so much , you lot r sooooo good at this stuff. really do appreciate it .
Colin X

 

[Marcelo Branco]

he he he sooooooooooo good thanks ever so much , you lot r sooooo good at this stuff. really do appreciate it .
Colin X

You are welcome.

Tks for the feedback and for the kind words

M.