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

 

[jim may]

Provide sample data in c3:c12 and f3:f12; gr1:gr510 also WITh sample expected results

 

[gl45]

Mr. Jim,

Range c3:c12 can contain from 5.0 to 9.0
Range f3:f12 can contain from 96.0 to 158.4
Range gr1:gr510 contain from 50 to 113 in no particular order.

If cell c3=8.5 and cell f3=152.2 the expected result in cell ab3=50 or
If cell c3 =6.0 and cell f3=112.3 the expected result in cell ab3=79

Thanks

 

[jim may]

OK, let's say c6 = 7.0
further f7 = 125.0
You want to lookup what? in Range gr1:gr510

 

[gl45]

Mr. Jim,

I need only the data that refers to c3,f3, c4,f4, c5,f5 and so on.
By your example
c6=7.0
not f7=125.0 but f6=125.0 would fetch 84 from the vlookup table
Thanks

 

[jim may]

This sorta thing **always** confuses me...
so how is Excel going to know to get (fetch) 84
from the Value 7 and 125?
Daaaa...

 

[gl45]

Mr. Jim,
Sorry for the confusion. The vlookup table is composed:
range gp1:gr510

GP1:GP510 GQ1:GQ510 GR1:GR510
5 96.0 100
5 96.1 99
5.5 102.0 101
6.0 108.4 98

If c3=5.5 and f3=102.0 then get 101 or
If c3=6 and f3=108.4 then get 98
Thanks

 

[jim may]

Ok - Here's what I'd do.

Insert a New Column Before (to the left of) your Col GR
in the New GR1 cell enter =GP1&CQ1 and Copy down as far as is necessary

then enter =VLOOKUP(C3&F3,GR$1:$GS$4,2,FALSE) >> should produce 98

Using your last small example

 

[jim may]

correction..

=GP1&GQ1 and Copy down as far as is necessary

 

[gl45]

Mr. Jim,
Thank you very much, worked like a charm