Hi, I am using this formula, which is hopefully self-explanatory
in B7...
=IF(ISBLANK(C7)," ",IF(SEARCH(C7,$B$1:$H$1,1),OFFSET($B$1:$H$1,1,0), ""))

My problem is that C7 contains a formula (which returns a blank cell if
conditions aren't met). I assume ISBLANK thinks this formula means C7 isn't
blank. Is there another function I can use to get B7 to return a blank
result if C7 is also blank?

Many thanks
Vibeke