# Help with Vlookup

#### gl45

##### Board Regular
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
Thanks

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### jim may

##### Well-known Member
Provide sample data in c3:c12 and f3:f12; gr1:gr510 also WITh sample expected results

#### gl45

##### Board Regular
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

Last edited:

#### jim may

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

#### gl45

##### Board Regular
Mr. Jim,

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

#### jim may

##### Well-known Member
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

##### Board Regular
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

##### Well-known Member
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

#### jim may

##### Well-known Member
correction..

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

#### gl45

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

Replies
1
Views
482
Replies
4
Views
90
Replies
1
Views
357
Replies
1
Views
223
Replies
4
Views
247

1,191,054
Messages
5,984,381
Members
439,883
Latest member
onions44

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back