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

Hi,

It's always easier to understand your question if we can see it in context.

Please upload your workbook, or at least a representative sample, with notes referring to the cells involved and manually add the results you expect to see.

Anonymise the data since no doubt it is sensitive.

Regards

Hi,

Please upload to the forum and not an independent site whose provenance we don't know.