Results 1 to 12 of 12

Create VLOOKUP or INDEX/MATCH to copy values from Sheet 2 to Sheet 1

Threaded View

leog1969 Create VLOOKUP or INDEX/MATCH... 04-03-2013, 04:19 PM
djapigo Re: Need Excel function... 04-03-2013, 04:33 PM
leog1969 Re: Need Excel function... 04-03-2013, 04:47 PM
Harribone Re: Create VLOOKUP or... 04-03-2013, 04:54 PM
djapigo Re: Create VLOOKUP or... 04-03-2013, 04:56 PM
leog1969 Re: Create VLOOKUP or... 04-03-2013, 05:29 PM
leog1969 Re: Create VLOOKUP or... 04-03-2013, 05:22 PM
martindwilson Re: Create VLOOKUP or... 04-03-2013, 05:30 PM
leog1969 Re: Create VLOOKUP or... 04-03-2013, 05:38 PM
djapigo Re: Create VLOOKUP or... 04-03-2013, 05:53 PM
Harribone Re: Create VLOOKUP or... 04-03-2013, 05:55 PM
leog1969 Re: Create VLOOKUP or... 04-03-2013, 05:58 PM
  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    McAllen, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Create VLOOKUP or INDEX/MATCH to copy values from Sheet 2 to Sheet 1

    I have 2 worksheets (Sheet 1 and Sheet 2). I need to manually enter a value in sheet 1 cell A1 based on values on sheet 2 cells D1 thru O1.
    If Sheet 1 cell A1 = Sheet 2 cell D1 then copy Sheet 2 Cell D2 to Sheet 1 Cell D17 and Sheet 2 cell D3 to Sheet 1 cell D18 and Sheet 2 cell D4 to Sheet 1 cell D19 and Sheet 2 cell D5 to Sheet 1 cell D25..... (Notice the gap in cell range from D19 to D25). Any assistance would be appreciated. Thank you in advance.

    Not sure if VLOOKUP or INDEX/MATCH is the right function. That's why I'm posting for help here.
    Last edited by leog1969; 04-03-2013 at 04:49 PM. Reason: Was advised to do so by other forum user

Thread Information

Users Browsing this Thread

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

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