in D2:


=VLOOKUP(G2,Sheet1!$A:$B,2,0)

Copy down

HTH

"Anthony" wrote:

hi all
worksheet 1 range of values from a1 to a100.
corrseponding names in b1 to b100

worksheet 2 values from coluimn A worksheet 1 appear but in different order
in column G:need to have corresponding name from b column wksheet 1 appear in
d column worksheet 2

heklp pls

cheers anthony