+ Reply to Thread
Results 1 to 4 of 4

Vlookup with 2 sheets?

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    Vlookup with 2 sheets?

    Hi, sorry this is probably a really simple problem but I'm completely stuck, I've been trying to fix it for an hour now..

    I want my data to populate on Sheet2 in cell B3 so this is where the formula would go. On Sheet2 in A3 down, I have a list of fund names. I want it to lookup this fund name on Sheet1 (where they exist in column E, and populate with the contents of column C on Sheet1. I can't get this to work?

    Can anyone offer any help at all? I'd really appreciate it!

  2. #2
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Vlookup with 2 sheets?

    pls attach sample file kelly

  3. #3
    Forum Contributor
    Join Date
    07-17-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel for O365
    Posts
    197

    Re: Vlookup with 2 sheets?

    If you have the column of fund names in Sheet 1 in column E and what you're trying to look up in column C then a VLOOKUP is no good for you as it goes backwards.

    This should do it... In Sheet2 cell B3 and drag down

    =index(Sheet1!$C$3:$C$100,match(Sheet2!$A3,Sheet1!$E$3:$E$100,0),0)

  4. #4
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    Re: Vlookup with 2 sheets?

    This worked brilliantly, thank you !!!! :D :D

+ 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. Vlookup on 2 different sheets
    By albert28 in forum Excel General
    Replies: 3
    Last Post: 11-29-2013, 09:55 AM
  2. Replies: 8
    Last Post: 03-30-2011, 11:09 AM
  3. VLOOKUP Across Several Sheets
    By kayard in forum Excel General
    Replies: 3
    Last Post: 03-16-2010, 07:59 AM
  4. Vlookup across sheets, nested Vlookup possibly?
    By paid2mkgrlspanic in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-09-2009, 05:10 PM
  5. 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