Are you by any chance leaving in the quotation marks? If yes, this is probably the problem. Also, check to make sure that there is in fact a value in the referenced cell (B8). Otherwise that formula looks OK to me. Let us know if you can't make it work.