LookUp

B

Boris Vukobrat

I am trying to use vlookup function for the first time:
One sheet has table as below. I've named the range for lookup as "RB"
(Region Balance).
Region koef #Fl Hrs Amount
C1 1.00 6528 14.0 1600.00
C2 1.15 5320 23.3 1165.00
C3 0.94 5032 14.0 1500.00
...
C35
E1
E2
...
E42
N1
etc

We do somethig on this regions. One person work on several regions every
months. There are about 150 Regions and a dozen persons. I have to get
Total Amount for each person every months. So another table (sheet) looks
like

Name Region .. .. .. Amount
Peter C3 1500.00

Amount column on this table should be =VLOOKUP(B2;RB;5)
but it doesn't return 1500.00!?!

Sorry for long post, it seemed simple, but I couldn't solve this one


Boris Vukobrat
 
T

T. Valko

Try it like this:

=VLOOKUP(B2;RB;5;0)


--
Biff
Microsoft Excel MVP


I am trying to use vlookup function for the first time:
One sheet has table as below. I've named the range for lookup as "RB"
(Region Balance).
Region koef #Fl Hrs Amount
C1 1.00 6528 14.0 1600.00
C2 1.15 5320 23.3 1165.00
C3 0.94 5032 14.0 1500.00
...
C35
E1
E2
...
E42
N1
etc

We do somethig on this regions. One person work on several regions every
months. There are about 150 Regions and a dozen persons. I have to get
Total Amount for each person every months. So another table (sheet) looks
like

Name Region .. .. .. Amount
Peter C3 1500.00

Amount column on this table should be =VLOOKUP(B2;RB;5)
but it doesn't return 1500.00!?!

Sorry for long post, it seemed simple, but I couldn't solve this one


Boris Vukobrat
 
R

ryguy7272

BR should be the entire range, your lookup value is inside the range. Are
you doing that? I usde this:
=VLOOKUP(A3,BR,5)

With the range "A1:E3" named BR and got 1500.


Regards,
Ryan---
 
C

cemorganCO

I am trying to use vlookup function for the first time:
One sheet has table as below. I've named the range for lookup as "RB"  
(Region Balance).
Region  koef    #Fl     Hrs     Amount
C1      1.00    6528    14.0    1600.00
C2      1.15    5320    23.3    1165.00
C3      0.94    5032    14.0    1500.00
..
C35
E1
E2
..
E42
N1
etc

We do somethig on this regions. One person work on several regions every  
months. There are about 150 Regions and a dozen persons. I have to get  
Total Amount for each person every months. So another table (sheet) looks  
like

Name    Region  ..      ..      ..      Amount
Peter   C3                              1500.00

Amount column on this table should be =VLOOKUP(B2;RB;5)
but it doesn't return 1500.00!?!

Sorry for long post, it seemed simple, but I couldn't solve this one

Boris Vukobrat
Click to expand...

Hi Boris,

Try adding the Range_lookup to your function. Example VLOOKUP(B2;RB;
5,False)

Christina
 
Top