hi

in sheet1 i'm having 2 col thru a1:b6

VALUE CODE
100 DDP 111
50 DDP 222
200 DD 666
500 DT 030208 DDP 444
600 DP 555

in sheet2 two col thru a1:b10

CODE VALUE
111 100
222 50
444 500
333 200
555 600
666 200
777 100
888 200
999 400

how can i index col B (value) by matching col A (code) in sheet2 with
col B (code) in sheet1?


help pl!

-via135