+ Post New Thread
Results 1 to 2 of 2
How do you do....it? Thread, Excel formula, cell contents moved in Technical; Hi all, Hope this is in the right place! I have two Excel spreadsheets, where the data in speadsheet 2 ...
  1. #1
    Pete10141748's Avatar
    Join Date
    Nov 2007
    Posts
    1,365
    Thank Post
    106
    Thanked 220 Times in 130 Posts
    Rep Power
    86

    Excel formula, cell contents moved

    Hi all,

    Hope this is in the right place! I have two Excel spreadsheets, where the data in speadsheet 2 uses a formula to take the content from a cell on spreadsheet 1, ie:

    Spreadsheet 2 cell B2 = something + spreadsheet 1 cell B2
    Spreadsheet 2 cell B3 = something + spreadsheet 1 cell B3

    and so on.


    The problem is that the data that is on speadsheet 1 now needs to be moved around, so cell B2 could become B12, B3 could become B30, or any c ell in the B coloumn really!

    My question is, is there a way to tell Excel to look at the content of coloumn A (people's names) and find the right name, then take the value of the cell next to that name in the B coloumn?

    If so I imagine that the formula will need to be tweaked for each cell of speadsheet 2 as each cell will have a different name to search for on spreadsheet 1?


    Thanks in advance for any help you can give!

  2. #2


    Join Date
    May 2009
    Posts
    3,039
    Thank Post
    269
    Thanked 804 Times in 609 Posts
    Rep Power
    295
    If I understand what you are after correctly, then VLookup will do the job. You pass Vlookup the key, the range of cells where the data resides (including the key as the first column), an offset to the data column you want returned and a boolean which specifies whether you want an exact match or the nearest next lowest value. So, assuming you have in spreadsheet 1 a list, (Name, Age) running A1:B100 and in spreadsheet 2 you have a list of Names, you could then, in spreadsheet 2 next to the name (B1) say = Vlookup(A1,"Spreadsheet2"!A1:B100,2,false) and the value in B1 should then be the age.
    Last edited by pcstru; 20th August 2012 at 10:36 AM.

  3. Thanks to pcstru from:

    Pete10141748 (22nd August 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 06:18 AM
  2. Excel Formula
    By denon101 in forum How do you do....it?
    Replies: 3
    Last Post: 1st December 2008, 03:34 PM
  3. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 05:31 PM
  4. office for mac excel formula question.
    By russdev in forum Office Software
    Replies: 2
    Last Post: 9th May 2008, 11:51 AM
  5. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •