Find cell value in range, return adjacent value

Hi everyone,

I'm going to try this one using excel formulas. Here's what I'm working with:

1. Cell A1 contains a value like 12345
2. Range A2:Z2500 contains similar values including value A1
3. Final A1 in A2:Z2500, then return the value to the right of it

For example

Within range A2:Z2500, if cell W1562 contains value 12345 (as found in A1), then return the value in X1562.

Any ideas?

Thanks!!