Try this in B2:

=INDEX(Sheet1!E:E,MATCH(B$1,Sheet1!X:X,0))

Hope this helps.

Pete

On May 2, 4:20*pm, Connie Martin
wrote:
I can't get this formula to work: *In worksheet 2, I need a formula in B2
that will look up the number in B1 in the other worksheet in column X and
then return what's in col. E that's in the same row as col. X. *Hope this
explains what I'm trying to do. *Thank you. *Connie