Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2004
    Location
    Jacksonville, Florida, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #Value error (Excel 2000)

    I've got a somewhat complicated formula in a cell, and I would like the cell to remain blank until data appears in it. However, I keep getting a #Value error that appears in the cell until data appears. The formula is complicated enough so that I'm having trouble figuring out what to change to make this work. Here's the formula:
    =IF(ISERROR((VLOOKUP($C$4,'Quik ''n Dirty Tax Comp v14.xls'!range1,6,FALSE))*C23),"",VLOOKUP($C$4,'Qu ik ''n Dirty Tax Comp v14.xls'!range1,6,FALSE))*C23

    What do I need to change to get this thing to work?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: #Value error (Excel 2000)

    Put the C23 within the IF:
    =IF(ISERROR((VLOOKUP($C$4,'Quik ''n Dirty Tax Comp v14.xls'!range1,6,FALSE))*C23),"",VLOOKUP($C$4,'Qu ik ''n Dirty Tax Comp v14.xls'!range1,6,FALSE)*C23)

    Your formula will give the null ("") when the lookup is invalid, but then gives the error when you multiply the strings.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •