+ Reply to Thread
Results 1 to 5 of 5

#N/A problem

  1. #1
    Forum Contributor
    Join Date
    06-06-2007
    Posts
    248

    #N/A problem

    Dear sir,with best regards,i need your help to solve my problem in my sheet which contains this formula(=(LOOKUP(2;1/($O$8:$O$5000=Z15);$Q$8:$Q$5000)),when i pull it down i got (#N/A)against all blank cells,how can i get (0) or ( empty cell) instead of (#N/A).
    Many thanks in advance.
    Last edited by tofimoon4; 11-25-2009 at 04:02 PM.

  2. #2
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: #N/A problem

    If you're saying the #N/A is generated only when content of Z is blank then use a pre-emptive IF

    =IF(Z15="";"";LOOKUP(2;1/($O$8:$O$5000=Z15);$Q$8:$Q$5000))

    If the #N/A is being generated because the non-blank contents of Z can't be found in O range then you need to clarify for us the data type of the Q range - ie what is being returned by the LOOKUP - numbers / text or a mix ?
    (we ask because if the output data type is consistent we can use a secondary LOOKUP to avoid need for double evaluation of the original)
    Last edited by DonkeyOte; 11-25-2009 at 05:23 AM. Reason: typo

  3. #3
    Forum Contributor
    Join Date
    06-06-2007
    Posts
    248

    Re: #N/A problem

    Dear sir,with my appreciated,in(O) column i have (material details)(text) which we sold them daily ( i took them from the supplier list),in (Z) column ihave a scheduale of all the materials (to have details of selling,buying,prices changes)(text also),in(Q) column i have the prices of these materials ( i took them from supplier list)(numbers),in (AE) column i have above formula to get the last price which (contains the problem).
    I hope you shall solve this problem .

  4. #4
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: #N/A problem

    Perhaps best to simply revert to:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-06-2007
    Posts
    248

    Re: #N/A problem

    Thank you sir very much , it works very well .

+ Reply to Thread

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