Double Vlookup

[Peo Sjoblom]

=INDEX(C2:C10,MATCH(1,(A2:A10=G1)*(B2:B10=H1),0))

array entered with ctrl + shift & enter, assuming we are
retrieving from column C, where G1 holds one lookup and H1
another.. Or hardcoded assume we want 3 from A and
15 from B

=INDEX(C2:C10,MATCH(1,(A2:A10=3)*(B2:B10=15),0))

would return 4

Regards,

Peo Sjoblom

BGorches <bgor...@foth.com> wrote in message
news:cd2d01c2804e$67389100$39ef2ecf@TKMSFTNGXA08...
> I'd like to know how to set up the vlookup function when
> you have data arranged like this:
> A B C D E
> 1 15 1.2 4.5 6
> 1 18 2.2 6 8.2
> 1 22 3.1 7.1 9
> 2 15 3 5 6
> 2 18 3.1 5.1 6.1
> 2 22 3.2 5.4 6.2
> 3 15 4 4 4
> 3 18 5 5 5
> 3 22 6 6 6
>
> Once I use the value that would be in col A, I then need
> to use another value to match col B, then return the
> value from one of cols C, D or E.
>
> I call that a double lookup.

[BGorches]

Thanks Peo.

I thought it would be easy for newsgroup-ites.

>.
>

[BGorches]