Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup table value
I posted this in the Excel Workbook section, but I think it might nee
to be addressed in here as it appears to be more of a programmin question, than an excel questoin. Anyway here goes I have a formula that returns a value in sheet1. Then I have a tabl full of values, in the same workbook different sheet, that correspond to that formula. I need to look up the value returned in sheet1 an display the appropriate column/row where that value is located. Example: value returned is 3.175 The table goes form 21 to 65 on both columns and rows. 3.175 is located at 37 column and 54 row, which is also cell locatio R35. I need it to return the appropriate gears where B2:AT2 is Gear and A2:A46 is Gear A. Is it possible to do this? If I can do the above, then I will work on the next part below, but i it is possible to do both at the same time that would be even better. So for the next part, the values in the table are not exactly sa 3.175, but might be 3.140 or 3.1764. So I guess I need to find a wa to minimize the difference between all of them and take the cell wit the smallest difference. I might be getting in over my head, but it will make things a LO easier if I can figure it out -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
table lookup | Excel Worksheet Functions | |||
Table lookup | Excel Discussion (Misc queries) | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |