Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Content Lookup Function
I have a worksheet of 5 columns and many rows w/ a header row. The contents
will change daily. Col A (unique) is the search key and I want to lookup the contents in Col B and on. Example Worksheet Name Age Sex (Header row) Brown 42 M Smith 31 F Bush 55 M =ADDRESS(MATCH("Smith",A,0),1,4,TRUE) will give me the result "A3", which is the correct address for "Brown". What I really want is the age or sex for brown. I am not having any luck with Cell (Contents) function. Am I doing this the correct way or there is a better way of doing it? Thanks Les |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Content Lookup Function
Les wrote...
.... Name Age Sex (Header row) Brown 42 M Smith 31 F Bush 55 M =ADDRESS(MATCH("Smith",A,0),1,4,TRUE) will give me the result "A3", which is the correct address for "Brown". Presumably you mean the correct address for Smith. What I really want is the age or sex for brown. . . . Why not use =VLOOKUP("Smith",$A$1:$C$100,2,0) for age =VLOOKUP("Smith",$A$1:$C$100,3,0) for sex ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Content Lookup Function
Harlan,
Thanks. This works even better. Les "Harlan Grove" wrote: Les wrote... .... Name Age Sex (Header row) Brown 42 M Smith 31 F Bush 55 M =ADDRESS(MATCH("Smith",A,0),1,4,TRUE) will give me the result "A3", which is the correct address for "Brown". Presumably you mean the correct address for Smith. What I really want is the age or sex for brown. . . . Why not use =VLOOKUP("Smith",$A$1:$C$100,2,0) for age =VLOOKUP("Smith",$A$1:$C$100,3,0) for sex ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function to return date content of another cell | Excel Worksheet Functions | |||
is there a function for getting the content of a cell? | Excel Worksheet Functions | |||
How to lookup row # based on content of another column's cell | Excel Worksheet Functions | |||
lookup cell content in multiple files | Excel Worksheet Functions | |||
IF function - need to evaluate cell content in 2 separate files-#N | Excel Worksheet Functions |