+ Reply to Thread
Results 1 to 3 of 3

Reconciling to columns

  1. #1
    Registered User
    Join Date
    11-16-2010
    Location
    Arkansas, US
    MS-Off Ver
    Excel 2007
    Posts
    6

    Reconciling to columns

    I'm working on a three sheet workbook. There is 2 columns of numbers I am dealing with on one and two. Column B on sheet one is working number. Column B on sheet 2 is finished number. The column on sheet 3 is the daily input of order of appearance of the working numbers on sheet one.

    So on sheet two I have used the simple =Sheet3!A1 then populated the rest. This is how I assign the finished numbers. Now I need sheet one to reconcile. Is there maybe and INDEX MATCH combo I could use in D1 of sheet one, that will put the finish number in sheet one that goes with the working number?
    Attached Files Attached Files
    Last edited by Barcode30; 11-16-2010 at 10:17 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: Reconciling to columns

    Maybe you looking for this:

    =VLOOKUP(Sheet2!A1, Sheet1!$A$1:$B$100, 2, FALSE)
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    11-16-2010
    Location
    Arkansas, US
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Reconciling to columns

    That would work only It's not A1 I need it's B1

+ Reply to Thread

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