update a cell with info from another row

[Bob]

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

 

[Don Guillett]

Have a look in the help index for Vlookup

 

[WLMPilot]

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)

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,D15)

Good Luck,
Les