+ Reply to Thread
Results 1 to 5 of 5

VLookup Between 2 Sheets

  1. #1
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    VLookup Between 2 Sheets

    Hello. I have Sheet 1, Column A has a list of keywords. Sheet 2 Column C has a list of keywords as well and also contains a url in column O. I am trying to do a vlookup between the two sheets. The formula I am trying to place on Sheet 1, IF A2 = Sheet 2C2:C50 copies the url in the O column. I keep getting to many argument error. Anyone help me out? I am sure it is the formatting.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: VLookup Between 2 Sheets

    Try this in B2:

    =INDEX('Sheet 2'!O:O,MATCH(A2,'Sheet 2'!C:C,0))

  3. #3
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: VLookup Between 2 Sheets

    try:

    =vlookup(A2,Sheet2!$C$2:$O$50,13,FALSE)
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  4. #4
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Re: VLookup Between 2 Sheets

    Quote Originally Posted by 63falcondude View Post
    Try this in B2:

    =INDEX('Sheet 2'!O:O,MATCH(A2,'Sheet 2'!C:C,0))
    Worked. Fantastic. Thank you!

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: VLookup Between 2 Sheets

    You're welcome. Happy to help.

+ 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. [SOLVED] Import .xls file in .xlsm file using macro and vlookup the sheets in new sheets
    By pacificepoc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2018, 04:06 AM
  2. [SOLVED] Vlookup error ["VLOOKUP evaluates to an out of bounds range" in Google Sheets]
    By Jietoh in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 03-23-2017, 01:35 PM
  3. IF OR Vlookup (Vlookup against multiple sheets)
    By VegasL in forum Excel General
    Replies: 3
    Last Post: 11-29-2016, 02:30 PM
  4. vlookup between two sheets
    By Susht in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2014, 11:39 AM
  5. Replies: 8
    Last Post: 03-30-2011, 11:09 AM
  6. Vlookup across sheets, nested Vlookup possibly?
    By paid2mkgrlspanic in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-09-2009, 05:10 PM
  7. vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1