Results 1 to 21 of 21

VLOOKUP - N/A error

Threaded View

  1. 10-14-2014, 03:29 AM #18
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: VLOOKUP - N/A error

    with Vlookup first without changing anything.......

    Formula: copy to clipboard 
    =VLOOKUP(I2,IF(I2="YES",CHOOSE({1,2},I2,F2*0.5),CHOOSE({1,2},I2,F2)),2,0)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup Error
    By wnstar21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2014, 02:14 PM
  2. Iferror vlookup if error vlookup if x=Y,
    By rwmeis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2013, 08:24 PM
  3. How to error trap a vlookup that returns an error or #N/A
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2013, 12:01 PM
  4. [SOLVED] lookup - if(is error(vlookup and error messages meanings
    By grphillips in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-18-2013, 07:03 PM
  5. VLOOKUP IN VBA FAILING RUNTIME ERROR 1004 Application-defined or Object-Defined error
    By makemie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2012, 11:59 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1