Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup table help please
Using Excel 2003. I've tried, I just can't do this and need some help
please...(both table and data are representative of current spreadsheets). Table (age col A; years of service Row 1) A B C D E 1 30 29 28 27 2 62 100 100 100 100 3 61.5 100 100 100 4 61 100 100 5 60.5 100 Data: Col A = age; Col B = yrs/svs A B 1 54.5 28.2 2 61.8 29.2 3 23.6 11.8 How do I ask if age is more than 61 and yrs/svs more than 29, then 100, if not N/A? I will have to do this with several thousand rows with age range from 21 to 75, and yrs of svs similarly spanned. Thankyou for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup a corresponding value in another table | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
lookup table | Excel Worksheet Functions | |||
lookup or table, not sure what to do | Excel Worksheet Functions | |||
Lookup Table | Excel Worksheet Functions |