IF and VLOOKUP Functions - Revised

[Lea]

The table lost all alignment. The cell addresses are: lab%
= G8, project % = I8, exam % = K8, class % = L8. The
Grading table is in rows 18,19,20,21 in columns E and F
and the "Grade_Table" is named as a range J19:K23 (does
not include the title row) Hope this clarifies my previous
posting.

 

[Max]

Lea,

You should have posted this in your earlier thread,
to keep things together, not start a new thread
which fragments things and makes it tough to follow.

Pl see my reply to your earlier post
where I've hopefully provided a complete, workable solution <g>.

cheers
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email

 

[Lea]

Thank you Max. I've decided to break it down into more steps as you suggested. I was trying to work it out in one
I do appreciate your quick reply. Thanks again
Le

 

[Max]

you're welcome, Lea!

cheers
Max

 

[Max]

you're welcome, Lea!

Thanks for feedback.

cheers
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------

Thank you Max. I've decided to break it down into more steps as you

suggested. I was trying to work it out in one.