+ Reply to Thread
Results 1 to 5 of 5

Vlookup/hlookup/match/index?

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    6

    Talking Vlookup/hlookup/match/index?

    Hello Excel Forum!

    I need a formula that when I paste it into Column D, it will look up what is in Column A in the same row and if the value in B is "New" AND the value in Column A in the next row is the same as in the previous row AND the value in Column B in the second row is "TA Screen", then put the value in Column C of the first row into Column D of the first row.

    The data will always been in this order, if that helps.

    Also, I may be going about this completely wrong. Open to suggestions. Thanks in advance!!!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Vlookup/hlookup/match/index?

    you're explanation was a bit confusing lol, but see if this is what you want? copy this to where-ever you need it, and copy down...

    =IF(AND(B2="New",A2=A3,B3="TA Screen"),C2,"Not Found")
    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
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Vlookup/hlookup/match/index?

    Haha. I have been working on this for so long and got to =IF(AND(A1=A2,B1="New",B2="TA Screen"),vlookup( and I thought my brain was going to explode.

    So simple. Thanks.

  4. #4
    Registered User
    Join Date
    11-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    6

    Re: Vlookup/hlookup/match/index?

    duplicate post
    Last edited by FDibbins; 11-28-2012 at 07:47 PM.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Vlookup/hlookup/match/index?

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

+ 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