+ Reply to Thread
Results 1 to 4 of 4

lookup function problem

Hybrid View

  1. 03-09-2008, 05:39 PM #1
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Excel won't do that directly; you could use a more complicated formula,

    =if(iserror(JanLookup), if(iserror(FebLookup), if(iserror(Marlookup), "", MarLookup), FebLookup), JanLookup)

    ... or use the VBA solution at http://www.ozgrid.com/VBA/VlookupAllSheets.htm
    Last edited by shg; 03-10-2008 at 06:52 PM.
    Reply With QuoteRegister To Reply
  2. 03-09-2008, 05:43 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Threads merged.

    PALUCA, please don't post the same thread in two forums.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1