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/