VLOOKUP
Posted by DAVE on March 27, 2001 3:12 AM
NEED HELP ON V LOOKUP,
Posted by Mark W. on March 27, 2001 5:39 AM
Yes?
Posted by dave on March 27, 2001 7:29 AM
o.k. I have a column of peoples ID, and another with their rate it can be either base or away. I sorted the rate into 2 seperate worksteets, and need to add the base and away for each employee.
I have to do the same with each month of the year.
I think vlookup is the best option altough I know little on excel
Posted by Mark W. on March 27, 2001 7:55 AM
Try...
=VLOOKUP(A1,'Base'!Table,2,0)+VLOOKUP(A1,'Away'!Table,2,0)
where:
Table are the cell references (e.g., A2:B10) of
your data. The employee ID should be the left-most
column of this reference.
A1 contains the employee ID that you wish to lookup
Posted by Mark W. on March 27, 2001 7:57 AM
How is your data organized by month?
