I am using excel 2003, and trying to work out what is the easiet and best way
to run a a formula. the problem is i have a grading system in a cell which
has 8 ranges. i also have beside this the total manhours calculated for that
grade. the problem is the project is spread over various tasks and
assignments, so multiple grades can be used all over the place.
I am trying to see if there is a way to write a formula which would look up
for just certain grades from the coloumn, and then from that look up the
approiate manhours to give a year total.
Is this possible or is it asking too much of the programme?