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

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### countdredd

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!

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On