Results 1 to 3 of 3

IF ISNA Vlookup problem (with 2 different Vlookups)

Threaded View

thylander IF ISNA Vlookup problem (with... 03-09-2011, 09:28 AM
NBVC Re: IF ISNA Vlookup problem... 03-09-2011, 09:35 AM
thylander Re: IF ISNA Vlookup problem... 03-09-2011, 10:27 AM
  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    33

    IF ISNA Vlookup problem (with 2 different Vlookups)

    Hi,

    Have been working on this formula and want to add another argument.

    =IF(ISNA(VLOOKUP(C7&" - "&E7;'[Workbook1.xls]Total'!$H:$I;2;FALSE));"";((VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE))))

    What I want to do is when the first formula failes and returns a blank I want it to perform another Vlookup in just the range

    "VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE) ".
    I tried to put it like this:

    =IF(ISNA(VLOOKUP(C7&" - "&E7;'[Workbook1.xls]Total'!$H:$I;2;FALSE));((VLOOKUP(E7;'[Workbook1.xls]Total'!$C:$I;7;FALSE))))

    but then the values that was returned in the first scenario failes.

    Any ideas ?
    Last edited by thylander; 03-09-2011 at 10:26 AM.

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