Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i find a value in a range?
I'm trying to find a value from cell H2 that is in range a1:b38.
i,e: H2=1.3 but there's no equal value to it in the a1:b38 range, i'm trying to get a value that is in the cell CXX depending on the row that can contain the value of H2. For more clearness the a1=0, b1 = 1.6 and c1=15. Due H2=1.3 and it is contain between a1 and b1 (0 to 1.6) i'm trying to get the value in return of C1 (15). How can i do this? could you please reply to ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i find a value in a range?
Hi,
Try this =VLOOKUP(H2,A1:C17,3) Mike "mannymtz" wrote: I'm trying to find a value from cell H2 that is in range a1:b38. i,e: H2=1.3 but there's no equal value to it in the a1:b38 range, i'm trying to get a value that is in the cell CXX depending on the row that can contain the value of H2. For more clearness the a1=0, b1 = 1.6 and c1=15. Due H2=1.3 and it is contain between a1 and b1 (0 to 1.6) i'm trying to get the value in return of C1 (15). How can i do this? could you please reply to ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
Find the MAX number in range, then find... | Excel Discussion (Misc queries) | |||
how do I find the last value of a range.... | Excel Worksheet Functions | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) |