LOOKUP
 

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

LOOKUP
 

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

LOOKUP
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
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

LOOKUP
 

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

"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

LOOKUP
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
Thank you! You both had the same answer and it works great! I love this
newgroup! Connie

"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

LOOKUP
 

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

Pete

On May 2, 6:56*pm, Connie Martin
wrote:
Thank you! *You both had the same answer and it works great! *I love this
newgroup! *Connie



"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- Hide quoted text -

- Show quoted text -