| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
