+ Reply to Thread
Results 1 to 3 of 3

Compare cell function

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Compare cell function

    Hi,

    I am using Microsoft Excel 2007 for a data. In one .xls file I have data in sheet 1 and also in sheet 2. My problem is as defined below:

    In sheet one there are columns namely A, B, C and D and it has 1000 rows. In sheet two there are column namely A, B, C and D and it has 3000 rows. Now I want to compare data of Sheet1!B1 to Sheet2!B1 : Sheet2!B3000 and if match is found it will transfer that particular column C row value to Sheet1 C row value.

    Basically in above I tried to explain that I need a function which will compare Sheet1!B1 value to Sheet2!B1 to Sheet2!B3000 value, say if the value of Sheet1!B1 has a match found in Sheet2!B1000 then Sheet2!C1000 value will be copied to Sheet1!C1000.

    Hope everybody understands this, would be great if anybody in here would help me out with this.

    Thank You,
    Last edited by halfwit; 09-13-2010 at 11:31 AM. Reason: Forum Rules

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Compare cell function

    In Sheet1 C1 and copy down,

    =VLOOKUP(B1, Sheet2!B$1:C$3000, 2 FALSE)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-13-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Compare cell function

    problem got solved a++ support
    Last edited by shg; 09-14-2010 at 01:19 PM. Reason: deleted quote

+ 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