+ Reply to Thread
Results 1 to 5 of 5

perform vlookup if cell in column is not blank

  1. #1
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    365
    Posts
    292

    perform vlookup if cell in column is not blank

    Hi all,

    will be needing your help..

    I want my excel to perform a vlookup if the cell in that column is not blank

    Also i want excel to delete the vlookup value if the name is deleted.

    If possible i want excel to also remove the formula "=vlookup()" from the result column (column b)

    attached is what i've done so far.

    any help will do thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: perform vlookup if cell in column is not blank

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    365
    Posts
    292

    Re: perform vlookup if cell in column is not blank

    Thanks Jindon, its working, just another question, if I delete the name in Column A, i want the result also to be deleted. how can we achieve that? thanks

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: perform vlookup if cell in column is not blank

    Ahh, I see what you mean.
    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    365
    Posts
    292

    Re: perform vlookup if cell in column is not blank

    Thanks for your help Jindon!

+ 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. Help with formula - if cell is blank not to perform calclation
    By suegough in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2018, 07:06 AM
  2. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  3. VBA to Perform Vlookup when column is not blank
    By Bigred25 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2016, 04:23 AM
  4. Not perform sum if cell is blank
    By lauracvp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-15-2015, 11:39 AM
  5. [SOLVED] Only perform formula if another cell is non-blank
    By stevejfice in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2012, 10:47 AM
  6. Perform If function if the cell is blank
    By capnhud in forum Excel General
    Replies: 17
    Last Post: 01-20-2012, 11:40 AM

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