LOOKUP function problem?
I have a data sheet from A3:F59. I input a number in G12. G12 is a number
with one decimal point. I need to look up G12 in the collumn F3:F59 and find the exact or closest number to G12 and then go accross that row to the first column and read out that cell on A3:A59. The numbers in the column F3:F59 are in 2 decimal points and in ascending order. I used the formula: LOOKUP(G12,F3:F59,A3:A59) For some numbers, it works fine but if the G12 falls between 2 numbers on F3:F59, it returns the cell above the closest number. I tried both vector and array formats for LOOKUP but no results. How can I fix this problem as I need to get the cell which is the closest to the value of numbers in F3:F59? Thanks for your help. Dori |
All times are GMT +1. The time now is 07:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com