Lookup function?

[Spursgirl]

I'm not sure if I'm using the right function, but I have a row of test
results and some cells have the option for a "pass/fail" result (not a number
or a grade).

I want to summarise the results from each section of the test, so am adding
the scores quite happily. However, if one of the questions is failed, this
needs to be shown in the summary.

I have tried to use Lookup but it won't display "Fail" in a cell on the
summary.

Any help would be greatly appreciated.

Thanks

 

[Spursgirl]

Hi Simon
Many thanks for your reply, which taught me some stuff I didn't know, but
didn't answer my question, because I obviously phrased it badly!!

The cells to which I was referring do not have a number in them; they have
the word "Pass" or "Fail". I wanted to be able to link that result to a
summary spreadsheet, so that I could enter "Pass" or "Fail" in each page of
the workbook and then report the question which this related to on the
summary sheet.

Example of summary sheet:-

Section A Section B Questions Failed

25 30 A3, B7


This is because there are certain questions which require a pass, otherwise
it is an automatic fail, regardless of the other scores.

I do not know if it is possible to do this automatically, rather than having
to check each page of the workbook and then keying the information in.

I really appreciate your response, and would be grateful for help on this
from you (or anyone else).

Thanks