Value of a cell based on three conditions

R

Rak

Hi
I am working with Excel that has multiple sheets in it. I am trying to
populate the value from one sheet to another based on three conditions. What
function can I use to accomplish this?


Example:
Sheet 1

Week Starting 6-Aug-07 29-Oct-07
Team Member FT TR BR FT TR BR
not required
Name One 26 54 22 11 8 30
Name Two 85 11 8 29 2 80


Sheet 2
6-Aug-07
FT TR BR
NAME Planned Actual Planned Actual Planned Actual
Name One 0 0 0
Name Two 0 0 0


I need to set the Actual field for Name One to 26 based on Week Starting
from sheet 1 = date on sheet2, FT on sheet1 = FT on Sheet 2, Name One on
sheet1 = Name One on sheet2.
 
Top