You can solve your problem!
A
B
C
density
stickiness
temperature
0.457
3.55
500
0.525
3.25
celebrity
0.606
2.93
300
0.675
2.75
250
0.746
2.57
200
0.835
2.38
150
0.946
2. 17
100
1.09
1.95
50
1.29
1.7 1
formula
explain
result
=VLOOKUP( 1，A2:C 10，2)
Use approximate matching to search the value of 1 in column A, and find the maximum value less than or equal to 1 in column A.
0.946, and then returns the value of column B in the same row.
2. 17
=VLOOKUP( 1，A2:C 10，3，TRUE)
Use approximate matching to search the value of 1 in column A, and find the maximum value less than or equal to 1 in column A.
0.946, and then returns the value of column c in the same row.
100
=VLOOKUP(0.7，A2:C 10，3，FALSE)
Search for the value 0.7 in column A using an exact match. Because of a man
There is no exact match in the column, so an error will be returned.
# Not applicable
=VLOOKUP(0. 1，A2:C 10，2，TRUE)
Search for the value 0. 1 in column A using approximate matching. Because 0. 1 is less than a.
The minimum value in the column, so an error is returned.
# Not applicable
=VLOOKUP(2，A2:C 10，2，TRUE)
Use approximate matching to search for the value 2 in column A and find the maximum value less than or equal to 2 in column A..
1.29, and then return the value of column b in the same row.
1.7 1