Excel 2007 : Index, Match, True returning #NA??

[=INDEX(C35:C66,MATCH(TRUE,C35:C66<>"",0))] entered with shift, ctrl, enter

Heres the formula. I am looking up the last cell contents in the column which works well. However, where there is a column with no cell contents i.e blank cell or formula, it is showing #NA.

Can anyone tell me how to keep the results cell empty please and get rid of #NA

Thanks in advance,

Chambo


SHG, many thanks. Its put a conditional format into the blank cells but I can sort that. I would be stuck without the support from this forum and guys like you. Thankyou.

=iferror(index(c35:c66, match(true, c35:c66<>"", 0)), "")