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

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

Hi Max,
Thanks, I tried that but for some reason it returns #VALUE! I am not sure
why. Any ideas?
I guess I could insert another coloumn and then use ISERROR, but it seems
clunky.
Thanks
Vibeke

"Max" wrote:

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

Maybe you need TRIM ..
Try: =IF(TRIM(C7)="","", ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Vibeke" wrote:
Hi Max,
Thanks, I tried that but for some reason it returns #VALUE! I am not sure
why. Any ideas?
I guess I could insert another coloumn and then use ISERROR, but it seems
clunky.
Thanks
Vibeke

Hmmm. Never used TRIM before, so it's nice to know about it, but I couldn't
make it work either. I should have mentioned, I am using SEARCH because C7
contains text and a date (and is based on a VLOOKUP) - so it's not just
straight text.

Many thanks for your suggestions.

"Max" wrote:

Maybe you need TRIM ..
Try: =IF(TRIM(C7)="","", ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Vibeke" wrote:
Hi Max,
Thanks, I tried that but for some reason it returns #VALUE! I am not sure
why. Any ideas?
I guess I could insert another coloumn and then use ISERROR, but it seems
clunky.
Thanks
Vibeke

Couldn't help but feel that the scope has since crept beyond your original
issue,
Is there another function I can use to get B7 to return a blank result if C7 is also blank?

Try:
=IF(TRIM(C7)="","",IF(ISERROR(SEARCH(C7,$B$1:$H$1, 1)),"",OFFSET($B$1:$H$1,1,0)))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Vibeke" wrote:
Hmmm. Never used TRIM before, so it's nice to know about it, but I couldn't
make it work either. I should have mentioned, I am using SEARCH because C7
contains text and a date (and is based on a VLOOKUP) - so it's not just
straight text.

Many thanks for your suggestions