Find Value in a Range Table with Values

[jamiguel77]

hi i have this table:


A B C

A14 0-4.5
T54 4.6-7.8
U87 7.9-11.6
G65 11.7-18.8
Y56 18.9-20.5
F54 20.6-27.8

if the value to find is: 8.5 then I need return with a formula the value of column A, in this case: U87 other sample:
if the value is: 5.8 the value that need return is: T54

wich is the formula?

thanks

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F
1	Value	Lower	Upper		Lookup Value	Result
2	A14	0	4.5		8.5	U87
3	T54	4.6	7.8
4	U87	7.9	11.6
5	G65	11.7	18.8
6	Y56	18.9	20.5
7	F54	20.6	27.8
8
Sheet6

Cell Formulas
Range	Formula
F2	=LOOKUP(E2,B2:B7,A2:A7)

 

[jamiguel77]

Strange i get a #N/A in spanish the formula is: =BUSCAR

other way?

thanks

 

[Eric W]

Try:

=INDEX(A2:A7,MATCH(E2,B2:B7))

 

[jamiguel77]

not work, continue the #N/A but i think wich is the problem my table have 2 or 3 decimals... and fail.....


checking

 

[Eric W]

Check to see if your data is numeric, or if it's numbers saved as text. That would cause a problem.