I am trying to pull information from one work sheet to another.

on one work sheet in colomn A there are several names and in column B there
are several numbers.

A B
1 frank 10
2 billy 5
3 carol 6
on a seperate work sheet

A B C D
1 frank ? carol ?
2 billy ? frank ?
I need for excell to look at sheet 1 for carol and put the number into the
? box

can someone help me