• 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.

Formula to show blank cell

Jet Fusion

Member
Hi all

Is there a way to change this formula to show a blank cell until a value gets added to the adjacent cell.

=LOOKUP(2,1/(A1:B10<>""),A1)

Thank you :)
 

p45cal

Well-Known Member
Could you say where you're putting this formula? What's it designed to show? Is it being copied across? or down?
What's it currently showing when there's no value in the adjacent (adjecent to what?) cell?
 

Jet Fusion

Member
Hi @p45cal

Sorry should have given more info. I have attached a file. Hope this helps. The error I am getting is #N/A so I want it to show a blank cell until a value is entered in anywhere from sheet 2 B5:B100.

Thanks :)
 

Attachments

pecoflyer

Active Member
Using absolute references for your range removes the error
But what are you trying to do ? Please explain some more and add some manually caluclated results?
 

pecoflyer

Active Member
Perhaps share your solution with the board ?
And if a prominent member like p45cal does not fathom what you are doing, then your example is unsufficient
 
Top