Feeding through to a Summary Tab

[Excel_77]

Hi All,

I have a "Summary" tab that records a list of subject in column B2 onwards, in Column C1-E1 there are heading with peoples names that relate to my three sub tabs, the sub are named "David," "Mike" and "Susan".

So in C2 of the "Summary" tab, I want to look at the subject in column B, then go to the tab called "David", match the subject in column G and return the corresponding value in column H of tab "David".

Is this possible and if so how?

Thanks in advance

 

[Excel_77]

Highlight the cells that contain the formula | press CTRL+1 | Select "Custom" from the "Category" list on the "Number" tab | in the "Type" text box enter ;;"NA" | Click OK

That worked, so I assumed it was customised for "0" and this just changed it to "NA".

The absolute final thing I need now that the code is working is to understand what it mean, could you give a brief overview? I am frankly confused.

 

[FormR]

That worked, so I assumed it was customised for "0" and this just changed it to "NA".

Good to hear yes, that's correct.

could you give a brief overview?

I'm not sure it would be all that brief - a good way to aid your understanding would be to go through the help files for the various functions being used and step through the calculation using the "Evaluate Formula" option on the "Formulas" tab to see what each part of the formula is returning and how that is fed into the next part.