Results 1 to 5 of 5

Help getting a V Lookup to return a blank based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    64

    Help getting a V Lookup to return a blank based on cell value

    Hi all. Please see attached sheet. I have a VLookup which will add start/finish and meal relief times. I am trying to figure out how to leave a cell blank for a day when the times are not required. In the sheet I only want the times to show on Mon, Wed, Thu and Fri. For Tue, Sat and Sun I want the times blank.
    What I need os for the VLookup to return a blank cell when the weekday cell value is '*'
    What am I missing?

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] V lookup - return value in another column if cell within v-lookup column is blank
    By Jacks18928 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2019, 06:46 AM
  2. [SOLVED] Vlookup to return Yes or No based on cell blank or not
    By fastcar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2019, 12:29 PM
  3. [SOLVED] Lookup Next Blank Cell and Return Adjacent Cell
    By Ollie7957 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2016, 05:02 AM
  4. Lookup a blank cell in a Lookup table and return a figure.
    By jonnops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2014, 07:33 AM
  5. How to return a blank cell based on if then criteria
    By azucar360 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-01-2013, 04:05 PM
  6. VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY
    By Scott Lolmaugh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2006, 07:10 PM
  7. Return of blank cell if lookup fails
    By TimM in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-23-2005, 12:40 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1