Results 1 to 3 of 3

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

Threaded View

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

    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.

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