+ Reply to Thread
Results 1 to 3 of 3

Completely Lost with VLOOKUP

  1. #1
    Registered User
    Join Date
    Los Angeles, CA
    MS-Off Ver
    16.19 for Mac

    Question Completely Lost with VLOOKUP

    Okay, I'll try to structure this as understandably as possible:

    I have an Excel Spreadsheet with 4 tabs
    • The first tab is my base of operations
    • I want to pull information from the 4th tab and match it with items on the 1st tab
    • The first tab has a "Content ID" in the "A" column
    • The 4th tab has that same "Content ID" and "rt id" in the "C" and "H" columns respectively

    So what I'm trying to do is bring forth the "rt id" to the "D" column of the 1st tab by matching the "Content ID"s that are found in both tabs and are identical.

    The next issue is:
    • Once I have the "rt id" pulled to the 1st tab I want to query the 3rd Tab Column "G" and see if the corresponding "rt id" on that tab says "Yes" on the "G" column of the 3rd Tab.
    • If it does I want to just populate a "True" or "False" on "Q" column of the 1st Tab

    • I want to query the 2nd tab columns "D" "E" and "F" to see if they say "False"
    • I would ideally use the "Content ID" found on Column "A" of both tabs as they are the same
    • If it does come back as "False" I would like the answer "Yes" to populate in Column "R" of the 1st Tab
    • If it comes back "True" I would like it to populate "No" in Column "R" of the 1st Tab

    I have looked over tutorials, but it doesn't seem to ever work and I am banging my head against the wall.

    Some more information:
    • 1st Tab is called custom_offers
    • 2nd Tab is called Differential
    • 3rd Tab is called RT
    • 4th Tab is called Content

    Any help is appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: Completely Lost with VLOOKUP

    Hi, welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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


  3. #3
    Registered User
    Join Date
    Los Angeles, CA
    MS-Off Ver
    16.19 for Mac

    Re: Completely Lost with VLOOKUP

    I've attached a document with Dummy data in the fields that are pertinent and descriptors beneath those columns being used. I hope this helps as I am so completely lost.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula help (SumIf totals caculations COMPLETELY LOST!)
    By thekiddzac in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-22-2015, 12:31 AM
  2. Replies: 3
    Last Post: 03-29-2013, 12:09 PM
  3. Replies: 3
    Last Post: 11-16-2012, 01:23 AM
  4. Excel 2007 : COMPLETELY lost in VBA
    By DXP in forum Excel General
    Replies: 1
    Last Post: 06-05-2012, 04:31 AM
  5. Please help, i am completely lost
    By cozzienz in forum Excel General
    Replies: 3
    Last Post: 07-02-2011, 02:57 AM
  6. need urgent help: completely lost/stuck with vlookup issue
    By jimmyjj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2006, 10:35 PM
  7. completely lost
    By clueless in forum Excel General
    Replies: 4
    Last Post: 07-11-2005, 02:05 PM

Tags for this Thread


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