• 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 :)
 
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?
 
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

  • Formula show blank.xlsx
    10.5 KB · Views: 12
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?
 
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
 
Back
Top