+ Reply to Thread
Results 1 to 3 of 3

Can Vlookup set a cell in the same Row to True?

  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    84

    Can Vlookup set a cell in the same Row to True?

    Hi, again, Excel-ers,

    In Excel 2007, I've got a Vlookup that works.
    It finds what I want it to find.
    Is it possible to have the same function SET a Cell in the same (found) Row to True (or False)?
    Conceptually, it should work like...
    =IF(ISERROR(VLOOKUP("abc",B1:D10,2,FALSE)),"","Found abc" (AND SET Column 3 to TRUE)).

    Can that be done?

    Thanks.

    Mark53
    Last edited by Mark53; 01-11-2011 at 04:31 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Can Vlookup set a cell in the same Row to True?

    No. A formula can not physically alter the content of any cell other than itself.

    Using formulae alone you would need a formula in "Column 3" which refers to the result of your VLOOKUP and adjusts its own content accordingly.

    If this is not viable then you're looking at VBA.

  3. #3
    Registered User
    Join Date
    09-28-2010
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Can Vlookup set a cell in the same Row to True?

    Darn.

    Ah, well... Can't do it. Darn.

    Never worked with VBA... just looked it up...
    I didn't even know what VBA was an acronym for until a minute ago.

    OK... I'll submit another thread with an explanation of what I need to do.

    Thanks, Don.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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