Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a lookup table that I need to reference. based on a 3 digit # such as
"2.22", I need to be able to find the cross section on the lookup table. Based on numbers across the top and down the left side; If I have the number 2.22, it will return for me .15 from the table lookup table (made up values) .00 .01 .02 .03 .04 ... .09 2.0 .31 .32 .33 .34 .35 ... .50 2.1 .21 .35 .51 .51 .25 ... .85 2.2 .53 .52 .15 .52 .51 ... .81 2.3 .89 .58 .23 .45 .15 ... .15 -- Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex Lookup | Excel Discussion (Misc queries) | |||
Complex lookup | Excel Worksheet Functions | |||
Complex Lookup | Excel Discussion (Misc queries) | |||
Complex Lookup | Excel Worksheet Functions | |||
Complex lookup | Excel Worksheet Functions |