Maybe this:
=IF(ISNA(LOOKUP(B7,Processes!$B$5:$C$150,FALSE))," ",LOOKUP(B7,Processes!$B$5:$C$150,FALSE))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Lisa Cowan" wrote:

I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",LOOKUP(B7,Processes!$B$5:$ B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa