Need to lookup values, and perform calculation to populate field

G

Gauthier

Hi there...i'm hoping u can help me...i'm using excel 2000 and have
knowledge is limited in the area of working with functions...

Below is a sample database - the actual database will contain approx. 300 or
so records...i'm trying to find a way to automate the task of looking up,
and calculating the values for the BLEND column...

SAMPLE DATABASE

TITLE REGION RESULT1 RESULT2 RESULT3 BLEND
Sec 02 na na na
100 *
Sec 02 na na na
100 *
Analyst 02 na na na
na
Admin 02 na na na na
Mgr 01 99 104 75 na
Mgr ** 02 102 105 90 na

- I would like the BLEND column to automatically FIND the values required to
CALCULATE, and POPULATE its contents

- only those records which indicate a "Sec" title should have a BLEND value

- find the "Mgr" in the same REGION as the "Sec" (in this case it would be
"02") and perform the following calculation, based on the data in the "Mgr"
record:

sum(102*.5)+(105*.25)+(90*.25)
to re-inerate - the 102, 105, and 90 are obtained from the RESULT1,
RESULT2, and RESULT3 columns in the "Mgr" record...

i thought the beginning would start with: " =if(title="Sec", if.... "
that's as far as i got with my LIMITED knowledge...

i appreciate your help!

Sandi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

my latest C++ excel OLE automation code 4
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month 4
I need to do a calculation based on the values in two cells 2
Inserting a value based on a calculation from another sheet 3
Using excel for a colour calculation 4
Gant Chart/Programme Progress Monitoring 2
Using Lookup Query with Calculated Value in Table ComboBox 2
multiple ranking (sorting), based on diff. criteria 0

Top