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