Numbers Formatting Help (HLOOKUP & VLOOKUP)

Discussion in 'Mac Apps and Mac App Store' started by BentwoodBlue, Mar 30, 2008.

  1. BentwoodBlue macrumors member

    Joined:
    Aug 6, 2007
    #1
    I am trying to create a form in Numbers from data that has already been inputed.

    When I use HLOOKUP or VLOOKUP and the target field is blank the command returns a zero. Does anyone know how I can just make it return the blank field instead of the zero?

    Thanks,
    Michael
     
  2. mackindergarten macrumors 6502

    Joined:
    Feb 21, 2008
    #2
    Hi,

    one way I can think of, is to something like this:

    Code:
    =IF(ISBLANK(A9);"";<your calc here>)

    /Rupert
     

Share This Page