+ Reply to Thread
Results 1 to 7 of 7

Help please if statement with vlookup

  1. 06-12-2016, 04:22 PM #1
    PREMEDMEDIC
    PREMEDMEDIC is offline
    Registered User
    Join Date
    06-12-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Unhappy Help please if statement with vlookup

    Spreadsheet showing that pieces of one part are received complete. For instance part A has multiple pieces need to know when all 7 are completed.

    Column A Column B unique line number
    Part Name Date Received 123
    A 6/12/2016 456
    A 6/10/2016 789
    A NO 587
    A 5/25/2016 875


    on different tab in workbook I have done a vlookup to find part name, date received, unique line number.....but here is the problem I can not duplicate part name on this tab. I need maybe an IF statement that it just says complete, N/A, partial, and not done.

    Any help would greatly be appreciated because I am STUMPED !!!

    Thanks
    Reply With QuoteRegister To Reply
  2. 06-12-2016, 04:52 PM #2
    mongoose36
    mongoose36 is offline
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Help please if statement with vlookup

    Can you upload a sample workbook? It would help greatly.
    If your questions has been answered to your satisfaction please don't forget to do the following:

    Add Reputation ... and ... Mark Thread as Solved

    Thanks,

    Ma 10:8b Freely you have received; freely give.
    Reply With QuoteRegister To Reply
  3. 06-12-2016, 11:31 PM #3
    Lemice
    Lemice is offline
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Help please if statement with vlookup

    Hello PREMEDMEDIC,

    Welcome to the forum

    I don't know if I got it correctly, but here's a sample file with yours and some dummy data, with 3 helper columns:
    1. Column D: Assemble the parts on the way, unique only, with this formula
      Please Login or Register  to view this content.
    2. Column E: counts the number of unique parts, on the way, with a simple formula
      Please Login or Register  to view this content.
    3. Column F: Tell the max number of unique parts for each Part Name, with an Array Formula
      Please Login or Register  to view this content.

    The only downside for this is that you have to sort Column A before hand. Also, idk if you still take the parts if the Date Received has a "NO" or not lol.

    I think VBA will be a much neater solution to this too
    Attached Files Attached Files
    Last edited by Lemice; 06-13-2016 at 02:27 AM.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem
    Reply With QuoteRegister To Reply
  4. 06-13-2016, 09:39 AM #4
    PREMEDMEDIC
    PREMEDMEDIC is offline
    Registered User
    Join Date
    06-12-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Unhappy Re: Help please if statement with vlookup

    Thank you for replies I have attached a sample workbook as suggested.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 06-13-2016, 10:54 AM #5
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,902

    Re: Help please if statement with vlookup

    Try this formula in B2 and down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    I have also included a helper column solution in columns D:F that may make it easier to understand what is happening in the event you need to modify solution to fit the actual data.
    Let me know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  6. 06-14-2016, 08:13 AM #6
    PREMEDMEDIC
    PREMEDMEDIC is offline
    Registered User
    Join Date
    06-12-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Help please if statement with vlookup

    Thank you so much for your help ....WORKED PERFECTLY !!!!! You saved me hours of headache and let me impress my new supervisor with the upgrade to tracking !!!
    Reply With QuoteRegister To Reply
  7. 06-14-2016, 08:16 AM #7
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,902

    Re: Help please if statement with vlookup

    You're Welcome and thank you for the feedback. Please take a moment to select Thread Tools from the menu link above and mark this thread as SOLVED. I hope that you have a blessed day.
    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. Using VLOOKUP with an IF statement, is this right?
    By kbsacto in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-02-2015, 01:43 PM
  2. [SOLVED] Vlookup and if statement
    By SENMAN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2014, 05:05 PM
  3. Help with IF Statement and VLOOKUP
    By Billmelton1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 04:47 PM
  4. Vlookup with IF statement?
    By tyetd in forum Excel General
    Replies: 3
    Last Post: 07-18-2012, 05:42 PM
  5. [SOLVED] Convert If statement with cell row reference calculations to vlookup statement
    By excyclist in forum Excel General
    Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  6. Using a VLOOKUP and IF statement inside an IF statement
    By Isis3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2011, 07:04 PM
  7. VLOOKUP with IF statement
    By Kay in forum Excel General
    Replies: 4
    Last Post: 08-17-2005, 10:04 PM

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