Retrieving Information IF Blank

[Dougiebn]

Retrieving Information IF Blank
If D6 to J6 is blank than A6 will not retrieve the name from Y6, (that is what I want it to do)

=IF(ISBLANK(D6:J6),"",(Y6))

But, D6 to J6 has formulas in the cells to retrieve information on taps in the same workbook example DBL gets its 2 from the tap DBL, a sheet where I enter the week by week info which totals the scores and displays it here on the main page.
What I want to know is, if there is a formula in each of the cells D6 to J6, but no info is showing, I noticed that it still retrieves the name from Y6 and places it in A6. Will the formulas in D6 to J6 be considered info even if the cells are blank?

This is something similar to the table I am using to give you an idea what I am trying to do.

1 A B C D E F G H I J X Y
2
3
4 DBL AGG 1001 AGG 71 FIN 71 BULLS TBB A
5 TEAM(1) Team 1
6 Dougie 2 239 85 1 3 18 0 Dougie


Thank You
Dougie

[Dougiebn]

How do you insert a table on this form, never did this before. Why I ask is so it will look better if I could put a table as it looks in excel.

Dougie

[XOR LX]

Hi,

It appears as if you are trying to pass an array of cells (D6:J6), rather than a single cell, to the ISBLANK function - though this, in the format you currently have, will almost certainly give incorrect results.

What precisely are you trying to say? That if any of D6:J6 is blank, then return ""? Or if all of D6:J6 are blank, then return ""?

Regards

[sktneer]

Try this rather than using isblank....

If you don't want A6 to retrieve a value from Y6 if all the cells from D6 to J6 are blank, use this

Please Login or Register  to view this content.

If you don't want A6 to retrieve a value from Y6, if any of the cells between D6 and J6 is blank, use this

Please Login or Register  to view this content.