Help with Vlookup

[gl45]

A newbie here.
I have numerical data in
range c3:c12
range f3:f12

Based on above two criteria I need to retrieve data in a Vlookup table, range gr1:gr510.
The Vlookup table range is gp1:gr510
Please help.
Thanks

 

[Colin Legg]

Hi,

Here's a way to do it without a helper column:

=INDEX(GR1:GR4,MATCH(1,(GP1:GP4=C3)*(GQ1:GQ4=F3),0))

When the formula is typed into the formula bar complete the entry with CTRL+SHIFT+ENTER, not just ENTER. This should automatically surround the formula with braces { }.

Hope that helps...

 

[jim may]

Yeah. And still another....

=SUMPRODUCT(--($GP$1:$GP$4=C3),--($GQ$1:$GQ$4=F3),$GR$1:$Gr$4)