Nested VLOOKUP's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

Sorry to bother you guys again, but I'm stuck

I have a table
a b c d
ZONE 5KGS 20KGS 30KG
1 6 7
2 7 9
3 8 11 1

Zone <------Occurences------
3 2 2 0
3 0 1
1 1 2

What I need to do is lookup the occurences of say zone 3 and multiply the values by the upper table. So the result of the first line = 38 (2*8+2*11+0*13

I've tried this but get a message with an error in formula

Any help appreciated

Thanks Alb

=VLOOKUP(I3,$A$2:$D$6,2,false)*J3)+VLOOKUP(I3,$A$2:$D$6,3,false)*K3)+VLOOKUP(I3,$A$2:$D$6,4,false)*L3
 
I can't follow the table in your post........it comes through kinda
scrambled here..........but offhand, I'd say you could use a few "(" in your
formula, like so........

=(VLOOKUP(I3,$A$2:$D$6,2,false)*J3)+(VLOOKUP(I3,$A$2:$D$6,3,false)*K3)+(VLOO
KUP(I3,$A$2:$D$6,4,false)*L3)

hth
Vaya con Dios,
Chuck, CABGx3


Alby said:
Hi all,

Sorry to bother you guys again, but I'm stuck.

I have a table:
a b c d
ZONE 5KGS 20KGS 30KGS
1 6 7 9
2 7 9 1
3 8 11 13

Zone <------Occurences------>
3 2 2 0
3 0 1 0
1 1 2 0

What I need to do is lookup the occurences of say zone 3 and multiply the
Click to expand...
values by the upper table. So the result of the first line = 38
(2*8+2*11+0*13)
 
Back
Top