+ Reply to Thread
Results 1 to 3 of 3

Nested Formula for IF(ISBLANK(VLOOKUP to look for blanks or put cell information

  1. #1
    Registered User
    Join Date
    04-10-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    0

    Nested Formula for IF(ISBLANK(VLOOKUP to look for blanks or put cell information

    I put a formula in cell J3 to look at data in cell A3. If cell A3 is blank then leave cell J3 blank. If cell A3 is not blank, put the data in cell A3 in J3.

    This is the formula I used:
    =IF(A3="";"";VLOOKUP($A3,EXCEL_ACP,11,FALSE)

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello feliciauop,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Nested Formula for IF(ISBLANK(VLOOKUP to look for blanks or put cell information

    Here is Introduce yourself not Introduce your problem

+ 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] ARRAY Formula: Seach Range and list row information of Non-Blanks
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-24-2014, 09:37 AM
  2. vlookup and isblank formula to return nothing
    By amartino44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2013, 06:59 PM
  3. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  4. combine vlookup,isblank,isna in one formula
    By kollasphotis in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-29-2009, 04:16 AM
  5. VLOOKUP & ISBLANK formula with multiple sheets help
    By trial&error in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-10-2008, 12:31 PM
  6. Cell sizing in a Vlookup formula to fit information.
    By Mike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2006, 01:15 PM
  7. [SOLVED] using a vlookup, can i use isblank to show an empty cell
    By Sandy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-09-2006, 06:55 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