+ Reply to Thread
Results 1 to 5 of 5

Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Midlands, Englands
    MS-Off Ver
    Excel 2010
    Posts
    6

    Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

    I have read several posts and spent several hours trying to do this so I am desperately hoping someone can help

    I have 2 sheets and I am trying to put the values in column E,F,G from sheet 2 in to column S,T and U in sheet 1 based on the booking references (Column A in both sheets)

    Please can you advise what formula I need to use, I have tried if and match and vlook up but just don't seem to be able to get it to work.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

    Can you attach a sample workbook? It would help.

  3. #3
    Registered User
    Join Date
    03-20-2012
    Location
    Midlands, Englands
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

    It wouldn't let me upload the original file so recreated a smaller version here.

    So I need the information from row B in sheet 2 to appear in row b in sheet 1 based on the booking references shown in column a

    Thanks in advances!
    Book1.xlsx

  4. #4
    Registered User
    Join Date
    03-20-2012
    Location
    Midlands, Englands
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

    HI Dennis

    I've uploaded a spread sheet the other day, are you able to help me?

  5. #5
    Registered User
    Join Date
    03-20-2012
    Location
    Midlands, Englands
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

    Quote Originally Posted by Dennis7849 View Post
    Can you attach a sample workbook? It would help.
    Hi Dennis, example uploaded 20/03 - please help

+ 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