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

1. ## 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

2. ## 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. ## 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),""),"")

4. ## 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. ## Re: Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP

No worries Rob, thanks for the rep

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

you are welcome , thanks for the rep

##### Users Browsing this Thread

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

#### 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 (?)
Template Usage (33):
• (1)footer
• (1)forumrules
• (1)gobutton
• (6)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (6)postbit_legacy
• (6)postbit_onlinestatus
• (6)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
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
• ./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_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_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• 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