in my workbook

on sheet 1, i have this infor

column A column B
mike 20
frank 10
billy 5

on sheet 2

column A column b column c colimn d
billy ? frank
?

the information in cloumn b on sheet 1 will change each week
i would like for excell to look at billy on sheet 2 column A find it on
sheet 1 column A then input the information in column B on sheet 1 into the
slot next to billy on sheet 2 column B.


--
MIKE HOLDER