Results 1 to 2 of 2

Thread: Need help writing a Formula

  1. #1

    Need help writing a Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My data is currently located in two worksheets
    In the first sheet is my collected data
    In the second sheet is the information that I manually copy from the first sheet
    73.85
    76.49
    In the first sheet the data I used are in two rows e.g.:



    In the second sheet I need to record the information in separate columns as listed below
    AaAaAaA
    X
    BAaABbAB
    ?

    X= 73.85 ?=76.49
    What I currently do is used the + and reference the cells in the first sheet.
    What I would like to do in the second column (?) Is somehow write a formula that would look at what is in the first column (x) and give me the result of 76.49
    Is there a way to do this?

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Hello
    With your numbers in col A of Sheet1 arranged as pairs, the first in each pair being in col B of Sheet2:
    In order to place the second value for each pair in Col D of Sheet2, put this formula into the same row:

    =INDEX(Sheet1!$A:$A,MATCH(B1,Sheet1!$A:$A,0)+1)
    copy down Col D for as many pairs as needed.
    Last edited by Hercules1946; 2015-10-23 at 10:01 PM.

Posting Permissions

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