+ Reply to Thread
Results 1 to 4 of 4

Alternatives to Vlookup.

  1. 06-05-2017, 02:23 PM #1
    andresndor
    andresndor is offline
    Registered User
    Join Date
    06-12-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    40

    Alternatives to Vlookup.

    Good afternoon.
    I have two sheets (attached) that share identical information (Name, Date, Amount), which represent individual purchases.
    I need to bring in the matching data from Sheet 2 into Sheet 1 but I can't figure out how.
    Usually I would just do a Vlookup but this won't work because there are no unique values in Sheet 2 to reference.
    So I'm just pasting in all of the sorted data by name, date and amount but I would imagine that there is formula (or macro) that would allow the data to follow automatically?
    Specifically I need the data from Sheet 2 B:D to flow into Sheet 1 G:I.
    Any ideas?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-05-2017, 02:47 PM #2
    Shareez Saleem
    Shareez Saleem is offline
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Alternatives to Vlookup.

    Match with the available information. Do one thing, just do a vlookup or index match by amount.
    In your sheet there are six amount repeated, so you only need to manually double check and change the records in sheet 2.
    Have a look at the attached sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 06-05-2017, 03:02 PM #3
    Bernie Deitrick
    Bernie Deitrick is online now
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,944

    Re: Alternatives to Vlookup.

    H and I seem to be redundant - not sure if the amounts always match....
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  4. 06-05-2017, 03:04 PM #4
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Alternatives to Vlookup.

    Use a pivot table
    Attached Files Attached Files
    Ben Van Johnson
    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. [SOLVED] VBA alternatives to VLOOKUP
    By KOstey80 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2017, 10:27 AM
  2. Alternatives to Index Match and Vlookup?
    By notredamesoph in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2014, 02:41 AM
  3. [SOLVED] Alternatives to using a for loop in cunjunction with vlookup
    By Bobcat1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2012, 09:17 PM
  4. Quicker Alternatives to VLOOKUP
    By ACM2 in forum Excel General
    Replies: 5
    Last Post: 07-08-2012, 03:35 PM
  5. vlookup issues & more efficient alternatives
    By thecircularwriter in forum Excel General
    Replies: 9
    Last Post: 08-12-2009, 03:58 PM
  6. vlookup issues / alternatives?
    By taz2009 in forum Excel General
    Replies: 1
    Last Post: 03-06-2009, 05:25 AM
  7. Nested IF Function and VLookup Alternatives
    By robert.holmes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 06:35 PM

Tags for this Thread

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