lookup formula help
 

I have a worksheet that captures auditing errors:
[A] [b] [C] [D] [E] [F]
1 [name] [course] [Course cost] [3.1] [3.2] [6.7]

second worksheet

[A ] [b]
1 25% 3.1
2 50% 3.2
3 80% 6.7

and so forth the values are in separate cells so each person can have
multiple errors.

another worksheet contains a column with he errors and another column next
to it with the funding value of each error ranging from 25% to 100%.

What I want to do is get the highest (max) value of percentage error so if
3.1 were 25%, 3.2 50% and 6.7 80% (as per example above) I want it to return
80% that way I can take the course cost for that learner and work out the
value of the error. so if course cost £150 then I would take 80% of 150.

I am not sure how to work out the lookup to get the max value from the row
of error codes.

hope I have explained myself

regards
Peter

Try the following...

=INDEX(Sheet2!$A$1:$A$3,MATCH(MAX(Sheet1!D1:F1),Sh eet2!$B$1:$B$3,0))

Hope this helps!

In article ,
"Peter" wrote:

I have a worksheet that captures auditing errors:
[A] [b] [C] [D] [E] [F]
1 [name] [course] [Course cost] [3.1] [3.2] [6.7]

second worksheet

[A ] [b]
1 25% 3.1
2 50% 3.2
3 80% 6.7

and so forth the values are in separate cells so each person can have
multiple errors.

another worksheet contains a column with he errors and another column next
to it with the funding value of each error ranging from 25% to 100%.

What I want to do is get the highest (max) value of percentage error so if
3.1 were 25%, 3.2 50% and 6.7 80% (as per example above) I want it to return
80% that way I can take the course cost for that learner and work out the
value of the error. so if course cost £150 then I would take 80% of 150.

I am not sure how to work out the lookup to get the max value from the row
of error codes.

hope I have explained myself

regards
Peter