I need to update a cell with info from another row.

Use A to find the correct row inn C. Move the value D into cell B:

A B C D
1 x 1 123
3 x 2 234
5 x 3 345
..... 4 456
..... 5 567

becomes:

A B C D
1 123 1 123
3 345 2 234
5 567 3 345
..... 4 456
..... 5 567

Have a look in the help index for Vlookup

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob" wrote in message
...
I need to update a cell with info from another row.

Use A to find the correct row inn C. Move the value D into cell B:

A B C D
1 x 1 123
3 x 2 234
5 x 3 345
.... 4 456
.... 5 567

becomes:

A B C D
1 123 1 123
3 345 2 234
5 567 3 345
.... 4 456
.... 5 567

I don't know what your limits are in terms of how many rows are involved (you
show 5), but here are two formulas. Just use one of the two:

1) If the entire column (C and D) are used, use this formula. I will use
B1 as the first cell for the formula. Copy and paste accordingly:
=LOOKUP(A1,C:C,D:D)

2) If you are only using x-number of rows, then use this formula. Again
using B1.
Adjust the number of rows within the formula to fit your list.
=LOOKUP(A1,C1:C5,D1:D5)

Good Luck,
Les

"Bob" wrote:

I need to update a cell with info from another row.

Use A to find the correct row inn C. Move the value D into cell B:

A B C D
1 x 1 123
3 x 2 234
5 x 3 345
.... 4 456
.... 5 567

becomes:

A B C D
1 123 1 123
3 345 2 234
5 567 3 345
.... 4 456
.... 5 567