Results 1 to 3 of 3

Thread: need lookup help with return value

  1. #1

    need lookup help with return value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am using lookup to capture the value in a cell, if the lookup cell has not yet been populated, how do I return a value of "blank"
    Last edited by R Flock; 2015-03-06 at 03:41 PM.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IF(Your_lookup()="","",You_lookup())

    of, if it currently returning an error because the lookup value doesn't exist, then

    =IFERROR(Your_Lookup(),"")


  3. #3
    Ty nbvc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •