+ Reply to Thread
Results 1 to 3 of 3

Copy cell contents between tabs provided cell references match (VLOOKUP?)

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Georgia
    MS-Off Ver
    Excel 2013
    Posts
    2

    Copy cell contents between tabs provided cell references match (VLOOKUP?)

    Folks, I need some help if you don't mind... I have 2 inventory reports: what my store has and what my supplier has. I need to copy Tab1:K# to Tab2:T# provided that Tab1:A#'s contents match Tab2:A#'s contents. The A column represents the SKU of the item, but there is a difference in the amount of SKU's in each (my store sells ~6,000 items, supplier has ~10,000 items), so it's not as simple as sort by column A and copy pasting column K to column T.

    For instance:
    On Tab 1, A2's value is [1], K2's value is [9.38].
    On Tab 2, A70's value is [1], K70's value is blank, but I need it to be [9.38], to match Tab 1's respective SKU.

    I almost thought I had it figured out with VLOOKUP, but I cant seem to get it right... It doesn't reference the correct number. Any help?

    Screenshots for reference

    First tab, from the wholesaler: http://i.imgur.com/zclV99c.png
    Second tab, store's stock: http://i.imgur.com/bzCuLAP.png

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Copy cell contents between tabs provided cell references match (VLOOKUP?)

    in sheet 2 K70 the formula is

    =VLOOKUP(A70,Sheet1!A1:L1000,11,0)
    I am not an expert. better solutions may be available
    [email protected]

  3. #3
    Registered User
    Join Date
    04-28-2014
    Location
    Georgia
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Copy cell contents between tabs provided cell references match (VLOOKUP?)

    That got it! My VLOOKUP formula was =VLOOKUP(A2,'Tab1'!A:A,K:K,0), which obviously didn't work. I think I halfway understand VLOOKUPs a little better now... VLOOKUP(The value you need matched, a range of data including the match and the cells needed to copy, the column number you want to copy, exact or loose match)

    Thanks a lot for you help! Google wasn't turning up anything close enough to my scenario for me to understand.

+ 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. Match 2 cells on 2 worksheets and copy contents of another cell
    By granitetek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2014, 03:03 PM
  2. File references provided in Cell Values
    By askrocks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2013, 09:56 PM
  3. Excel copy cell contents if two dates match
    By mrwalters in forum Excel General
    Replies: 3
    Last Post: 01-01-2013, 01:26 PM
  4. Copy If Match a cell contents
    By rmharrison in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2012, 07:48 PM
  5. selecting the cell that a vlookup or match function references
    By Elceller in distress in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2006, 09:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1