You guys were so great last time here is another one for you...

I have two 'scorecards' with an id number, name, and score. Both are sorted
by score in descending order. I would like to generate cumulative scorecard
with both scores and a summary score but when I try and look up the score up
based upon the ID I am getting incorrect results. There is a match for every
name so it isn't a a null error. The formula I'm using is as follows...

=IF(ISNA(LOOKUP($E43,'Phase I Scorecard'!$E$13:$E43,'Phase I
Scorecard'!$H$13:$H43)),"",LOOKUP($E43,'Phase I Scorecard'!$E$13:$E43,'Phase
I Scorecard'!$H$13:$H43))

--
Doug S