I am using the following formula =IF(ISBLANK(C5),"",LOOKUP(C5,$M$47:$M$80,$N$47:$N$80)). Works good except on the cells that are blank I get #N/A. For example if I point the formula to c6 and it blank it returns the error.

Thank for helping.