sorry, ill try again
This is the formula that I have in cell c22 of sheet 1 called form

=INDIRECT("Data!I" &RowIndex)
What i need the function to do is if column I contains no data for a
student do not display and move onto column J, if column j display data
then show if not move onto next column or something similar, each
column represents a subject
Hope this is a better explanation
cheers
paddy

On Jan 2, 5:06 am, "T. Valko" wrote:
Maybe a better explanation is in order. Be more specific.

Biff

"mcgrath383" wrote in ooglegroups.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- Hide quoted text -- Show quoted text -