1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Retrieving Cell Data and Reverse Lookup in separate spreadsheet (MS EXCEL 2010)

Discussion in 'Business Applications' started by countdredd, Nov 30, 2011.

Thread Status:
Not open for further replies.
  1. countdredd

    countdredd Thread Starter

    Joined:
    Oct 17, 2010
    Messages:
    4
    Retrieving Cell Data and Reverse Lookup in separate spreadsheet

    Hello Everyone,
    My name is Melvin and I work as an accountant in a Logistics Company. I am a newbie here and I implore

    your help in a major predicament with Microsoft Excel.

    Let me begin,

    Lets say I have 2 spreadsheets.

    1. The first document, SALEXCEL_1111 contains a large list of salary values of individuals of different

    pay grades. The Left Column is PAY GRADES namely with a letter and a number. For example, A1, A2

    upto A10, subsequently B1,B2 upto B10. I hope to bring to your attention that these values are not cell

    references but the actual data within the cells.
    And the lower row is that of SENIORITY in years.
    _______
    A1
    A2
    ..
    A10
    _______
    B1
    B2
    ..
    B10 | 2250 | 2500 | 2750 |
    _______

    SENIORITY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |



    2. The second document, SALEXCEL_2222 is that of a specific company branch office with employee

    details such as the name field, position and then PAY GRADE.

    NAME | POSITION | PAYGRADE | SENIORITY | SALARY

    XYZ | Accountant | B10 | 2 | XVALUE


    Now the biggest challenge is that, there are different employees with different pay grades and many

    such branch office spreadsheets. Here thankfully, the main database spreadsheet is a constant.
    Is there any way to obtain XVALUE by Looking up the paygrade and the seniority cell values in

    SALEXCEL_2222 and obtaining the required addresses and then by referencing SALEXCEL_1111 and

    looking up the cell data value of the PAY GRADE column and once that is obtained in SALEXCEL_1111,
    then moving across the SENIORITY ROW to arrive at the correct [XVALUE].

    For example,
    while in SALEXCEL_2222;
    if for the person XYZ who is an accountant with the paygrade B10 and seniority of 2 years,
    then the SALARY can be obtained by looking up in SALEXCEL_1111
    and looking down at the left PAYGRADE column arriving at B10,
    then looking across the SENIORITY column arriving at 2
    with the final XVALUE being 2500.

    This is the summary of my problematic predicament. :(
    Any help with this will be huuuuuugely and gratefully appreciated with all my heart! :D
     
  2. countdredd

    countdredd Thread Starter

    Joined:
    Oct 17, 2010
    Messages:
    4
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1029044

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice