+ Reply to Thread
Results 1 to 4 of 4

vlookup formula to ingnore perticular data

  1. 07-05-2014, 01:14 AM #1
    vanitarathod
    vanitarathod is offline
    Registered User
    Join Date
    06-18-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    35

    vlookup formula to ingnore perticular data

    Hi all,
    My question refers to below table.

    A B C
    1 - =vlookup(
    3 - =vlookup(
    6 NA =vlookup(
    2 - =vlookup(................

    In C column, I want to put vlookup formula for Column A data. But if cells in B column contains data "NA" then vlookup for that cell should be neglected.

    Please help.

    thanks in advance
    Reply With QuoteRegister To Reply
  2. 07-05-2014, 01:24 AM #2
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: vlookup formula to ingnore perticular data

    If you post a workbook with some sample data it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
  3. 07-05-2014, 02:09 AM #3
    vanitarathod
    vanitarathod is offline
    Registered User
    Join Date
    06-18-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    35

    Re: vlookup formula to ingnore perticular data

    Hi jacc,

    thanks for your reply.
    I am attaching sample excel file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-05-2014, 02:22 AM #4
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: vlookup formula to ingnore perticular data

    =IF(B1="NA","un-analysed",VLOOKUP(A1,F:G,2,0))
    try this formula in c1 and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    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. Formula to stop counting after perticular character appers in a cell
    By tushardnk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-22-2013, 06:53 AM
  2. Formula addition to ingnore blank cells
    By cassandralcoleman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-25-2012, 03:07 PM
  3. Filtering, Coping and pasting perticular range of data.
    By protocol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2011, 10:00 AM
  4. Excel 2007 : Vlookup to ingnore missing values
    By ChrisE in forum Excel General
    Replies: 1
    Last Post: 08-27-2009, 09:43 PM
  5. [SOLVED] ingnore nonexisting subrouitine
    By Jack Sons in forum Excel General
    Replies: 9
    Last Post: 09-12-2005, 10:05 AM

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