Results 1 to 3 of 3

Excel 2007 : trouble with vlookup and ISNA formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Indiana, US
    MS-Off Ver
    Excel 2007
    Posts
    1

    trouble with vlookup and ISNA formula

    I’m using Excel 2007. When I do a vlookup it returns #N/A if the cell is empty. I want the formula to return “0” if the cell is empty. I have attached a spreadsheet. Here is the formula that I wrote in cell B3 through B7:
    =IF(ISNA(VLOOKUP($A3,$E$3:$H$6,4,FALSE)),0,VLOOKUP($A3,$E$3:$H$6,4,FALSE))

    The problem that I’m having is that there are two similar account names in my data so the result is picking up the results from a similar account name instead of giving me “0”. The two similar accounts names are ** LIFO Inventory Reserve and 16900010 - LIFO Inventory Reserve. The result for ** LIFO Inventory Reserve is incorrect (cell B6). The results should be “0”. Instead it is picking up “PM” for account 16900010 - LIFO Inventory Reserve (cell H5). Why is my formula picking up “PM”? I can’t change the account names. How can I write the formula so that it picks up “0”?
    Help is appreciated. Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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