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



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Try it like this:

=VLOOKUP(B2;RB;5;0)


--
Biff
Microsoft Excel MVP


"Boris Vukobrat" wrote in message
news:op.t6kubygdp9o88x@boris...
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



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

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---

--
RyGuy


"Boris Vukobrat" wrote:

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



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

The lookup table is on a different sheet.

--
Biff
Microsoft Excel MVP


"ryguy7272" wrote in message
...
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---

--
RyGuy


"Boris Vukobrat" wrote:

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



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

On Feb 15, 10:47*am, "Boris Vukobrat"
wrote:
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

--
Using Opera's revolutionary e-mail client:http://www.opera.com/mail/

Hi Boris,

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

Christina