Maybe a better explanation is in order. Be more specific.

Biff

"mcgrath383" wrote in message
oups.com...
Hi

I have a workbook containing 3 sheets, I have taken the structure from
using excel as a mail merge, I have used indirect to draw information
from sheet 2 to sheet 1.
Sheet 2 contains grades for subjects, however not all students do all
subjects and I want a function that will only draw the information if a
grade is present within that specific column, I have tried using an If
function with indirect with no luck, any ideas gratefully received
cheers
paddy