Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - is it possible to...
Using '97
Is it possible to , for lack of a better term, do a "nested" lookup without having to name every possible range? Monday Hours Fred 20 Joe 27 Tuesday Hours Fred 30 Joe 35 Wednesday Hours Fred 20 Joe 28 Thursday Hours Fred 28 Joe 27 Friday Hours Fred 39 Joe 37 I want to be able to return the numbers of hours for Fred on Thursday, without having to name ranged for each day of the week. The actual problem I am working through involves many more factors of course, but that is the bare bones. I hope the formatting comes through Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - is it possible to...
=INDEX(INDIRECT("C"&MATCH("Thursday",A:A,0)&":C100 0"),MATCH("Fred",INDIRECT(
"B"&MATCH("Thursday",A:A,0)&":B1000"),0)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message ... Using '97 Is it possible to , for lack of a better term, do a "nested" lookup without having to name every possible range? Monday Hours Fred 20 Joe 27 Tuesday Hours Fred 30 Joe 35 Wednesday Hours Fred 20 Joe 28 Thursday Hours Fred 28 Joe 27 Friday Hours Fred 39 Joe 37 I want to be able to return the numbers of hours for Fred on Thursday, without having to name ranged for each day of the week. The actual problem I am working through involves many more factors of course, but that is the bare bones. I hope the formatting comes through Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - is it possible to...
Thanks, I'll give it a try.
"Bob Phillips" wrote in message ... =INDEX(INDIRECT("C"&MATCH("Thursday",A:A,0)&":C100 0"),MATCH("Fred",INDIRECT( "B"&MATCH("Thursday",A:A,0)&":B1000"),0)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message ... Using '97 Is it possible to , for lack of a better term, do a "nested" lookup without having to name every possible range? Monday Hours Fred 20 Joe 27 Tuesday Hours Fred 30 Joe 35 Wednesday Hours Fred 20 Joe 28 Thursday Hours Fred 28 Joe 27 Friday Hours Fred 39 Joe 37 I want to be able to return the numbers of hours for Fred on Thursday, without having to name ranged for each day of the week. The actual problem I am working through involves many more factors of course, but that is the bare bones. I hope the formatting comes through Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |