+ Reply to Thread
Results 1 to 5 of 5

LOOKUP TABLE -blank cell in the table array to return a figure

Hybrid View

  1. 03-28-2014, 08:30 AM #1
    jonnops
    jonnops is offline
    Registered User
    Join Date
    04-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    12

    LOOKUP TABLE -blank cell in the table array to return a figure

    My lookup table works perfect until there is a blank cell. I need there to be a blank cell in the table array and I want the blank cell to return the figure in the col_index_num but it is just returning a blank value rather than the dollar amount. I have attached an example, if someone can help that would be great. I'm referring to the formula in cell C7, when C5 has nothing in it should lookup A21 and give the figure of 30
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-28-2014, 08:46 AM #2
    ronald coletto
    ronald coletto is offline
    Registered User
    Join Date
    10-10-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: LOOKUP TABLE -blank cell in the table array to return a figure

    PLEASE explain better what u try to accomplish i may be able to help you out i do a lot =vlookup and if statements
    Reply With QuoteRegister To Reply
  3. 03-28-2014, 09:03 AM #3
    jonnops
    jonnops is offline
    Registered User
    Join Date
    04-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: LOOKUP TABLE -blank cell in the table array to return a figure

    C7 is not returning a value it is blank. I need it to give the value that is in B21
    Reply With QuoteRegister To Reply
  4. 03-28-2014, 09:04 AM #4
    ronald coletto
    ronald coletto is offline
    Registered User
    Join Date
    10-10-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: LOOKUP TABLE -blank cell in the table array to return a figure

    ok, after reading and thinking, i was able to understand your request, sadly =vlookup looks for values so here is one solution for you....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-28-2014, 09:08 AM #5
    AZ-XL
    AZ-XL is offline
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: LOOKUP TABLE -blank cell in the table array to return a figure

    b7 cell
    =INDEX($B$18:$B$32,MATCH(TRUE,(B5=$A$18:$A$32),0))
    then Ctrl+Shift+enter
    Appreciate the help? CLICK *
    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)

Similar Threads

  1. [SOLVED] VLOOKUP - If table array is blank, need it to return blank
    By bxk006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2014, 11:36 AM
  2. Lookup a blank cell in a Lookup table and return a figure.
    By jonnops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2014, 07:33 AM
  3. [SOLVED] Array Formula to Lookup and Return All Rows in Table that Meet Single Criteria
    By Torkel74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 10:41 PM
  4. Excel 2007 : vlookup to return a cell outside of table array
    By dasv in forum Excel General
    Replies: 0
    Last Post: 01-23-2012, 05:16 PM
  5. VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY
    By Scott Lolmaugh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2006, 07:10 PM

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