LOOKUP

[Connie Martin]

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

 

[Pete_UK]

Try this in B2:

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

Hope this helps.

Pete

 

[T. Valko]

Try this:

=INDEX(Sheet1!E:E,MATCH(B1,Sheet1!X:X,0))

 

[Connie Martin]

Thank you! You both had the same answer and it works great! I love this
newgroup! Connie

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you! You both had the same answer and it works great! I love this
newgroup! Connie

 

[Pete_UK]

Thanks for feeding back, Connie - so few do !!

Pete