Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions
I am trying to setup a spreed sheet that has a list off names and thier ages.
I want to be able to find the age on seperate table and choose the information next to it. my table has from age 70 to 110in row down and next to each age is a number. it is that number I need to go in to the field. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions
Check Debra Dalgleish's website for the VLOOKUP function.
http://www.contextures.com/xlFunctions02.html I'm pretty sure that will solve your problem. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jeannette" wrote: I am trying to setup a spreed sheet that has a list off names and thier ages. I want to be able to find the age on seperate table and choose the information next to it. my table has from age 70 to 110in row down and next to each age is a number. it is that number I need to go in to the field. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
Visible rows and functions that work | Excel Worksheet Functions |