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