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

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

Not open for further replies.
1. ### countdreddThread 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!

Joined:
Oct 17, 2010
Messages:
4
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.

over 733,556 other people just like you!