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!!

hi Glen,

That formula is assuming the lookup value is located in column A. It could be anywhere in the range A2:Z2500. It could be in column L, therefor the value directly to the right would be returned.

Thanks very much, Glenn. It see it works perfectly on your workbook but I'm getting a #Ref error. Does this formula only work if the data and results are on the same sheet perhaps?

Hi Glenn,

You are absolutely right, I didn't mentioned though I should have. I have tried your new format and there's one item that's throwing it off. In your formula:

Please Login or Register  to view this content.

cell

Please Login or Register  to view this content.

is actually located in Sheet2. I've tried just moving that cell reference to Sheet2 but I get an error. When it stays in Sheet1 it works perfect.

Apologies for not being clear enough on the sheet details.

Any ideas?