On the face of it, try changing your front IF check from:
=IF(ISBLANK(C7)," ", ..
to: =IF(C7="","", ..

Any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Vibeke" wrote:
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