+ Reply to Thread
Results 1 to 6 of 6

Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

    Hi,

    Can anyone please advise me on how to amend the syntax of my formula to check first to see if there is a value in cell ‘O2’ i.e. not empty/blank
    If the cell ‘O2’ is empty/blank then perform the Vlookup otherwise display the cell as empty/blank.


    =IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),"")

    Many thanks in advance

    Regards

    Rob
    Rob

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

    =IF(O2="",IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")

    OR

    =IF(ISBLANK(O2),IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

    =IF(O2<>"", IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")
    or
    =IF(isblank(O2), IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Re: Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

    PFDave & etaf,

    Excellent !! many thanks for your assistance it is very much appreciated


    Regards

    Rob

  5. #5
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

    No worries Rob, thanks for the rep

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

    you are welcome , thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Amend Formula To Check if Cell ‘A2’ Has Data Entered
    By robertguy in forum Excel General
    Replies: 5
    Last Post: 12-01-2016, 07:36 AM
  2. [SOLVED] Help to amend vlookup formula
    By mso3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-21-2016, 07:12 AM
  3. [SOLVED] Insert vlookup formula into next empty cell in column B
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2016, 05:55 AM
  4. Replies: 10
    Last Post: 06-12-2013, 12:12 PM
  5. How to find empty cell and insert vlookup formula
    By sathu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2013, 10:02 AM
  6. Replies: 3
    Last Post: 03-24-2011, 11:02 AM
  7. Perform a vlookup on a cell containing a formula?
    By Rupea22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2010, 12:11 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06408 seconds
  • Memory Usage 9,004KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (6)postbit_legacy
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1