• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help on formula

J

jayalaxmi

Active Member
Hi Folks,

I am struggling up with this formula.

Require your help on this..

this is my basic formula =(IFERROR(VLOOKUP($C10,'Week 1'!$C:$H,6,0),"None")

my vlookup has #DIV/0 error so i had used iferror to show it as none. But i need the data to be blank if there are no data available for the week.For eg i am currently having data for week 1 it should show it as none with the grey formatting and for week 2 i m not having the data but there are formula embedded in week 2 with the #DIV/0 error so i want to show it as blank.when the numbers are available in week 2 i want to show it as none otherwise blank with grey formatting.

Regards
Jaya
 
Jaya, better with a sample file...
I believe it is a follow up on your previous post. So I can guess a bit here on how the data looks like.

If you can check a cell - say B2 - in your "week"-sheets to be blank then a simple if might do the trick.
like = IF ( ISBLANK('Week1'!$B2),"",IFERROR(VLOOKUP($C10,'Week 1'!$C:$H,6,0),"None"))
 
Hi,

How you are getting #DIV/0 errors?
This must be a formula result hmm?, try IFERROR on those #DIV/0s.

Regards,
 
You must log in or register to reply here.
Back
Top