Results 1 to 2 of 2

Addition of ISNA or ISERROR to current IF & VLOOKUP Formula

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2011
    Location
    Cumbria
    MS-Off Ver
    Excel 2003
    Posts
    1

    Smile Addition of ISNA or ISERROR to current IF & VLOOKUP Formula

    Hi all, Just wondered if anyone could help me with this formula, I've tried a few different combinations but can't get them to work. I'm fairly new to the more complex excel formulas so any help would be much appreciated.

    Basically I have this formula which works fine:

    =IF($E$28=0,VLOOKUP($F$8,Data!$B$2:$O$65536,{2},FALSE),VLOOKUP($E$28,Data!$A$2:$O$65536,{1},FALSE))
    Except when I'm not asking it to look anything up it has #N/A sat in the cell. I know i need to as and iserror or an isnumber function somewhere but I can't seem to get it right! I just want the cell blank when not in use...

    Cheers,
    Dan
    Last edited by Dan_Millard; 03-30-2011 at 02:41 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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