Lookup Based on Range

I cannot get number to return based on range. For example I want to enter 3.5 into B2 and then have it search a table G2:G30 with corresponding values in H2:H30 and return the value on C2. The 3.5 would be in the G column with an associated value in H.

Try this in C2:

=INDEX(H:H,MATCH(B2,G:G,0))

I tried that formula and it comes up with #N/A. I am entering a 3.5 and there is a percentage value i am trying to return.

If that formula returned #N/A, that means that there are no cells in column G with 3.5 in it (or they are formatted as text, or have a leading/trailing space, etc.).

If you upload a small representative sample, along with the desired result of a working formula, we can trouble shoot it for you.

B C G
3.5 #N/A 1 33%
3.6 #N/A 1.1 37%
3.7 #N/A 1.2 40%
3.8 #N/A 1.3 43%
3.9 #N/A 1.4 47%
3.10 #N/A 1.5 50%
3.11 #N/A 1.6 53%

Does it matter that H is a formula? The number go all the way till 4

Please upload an actual Excel workbook.

Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

3.5 #n/a 1.00 33%
3.6 #n/a 1.10 37%
3.7 #n/a 1.20 40%
3.8 #n/a 1.30 43%
3.9 #n/a 1.40 47%
4.0 #n/a 1.50 50%
3.11 #n/a 1.60 53%
1.70 57%
1.80 60%
1.90 63%
2.00 67%
2.10 70%
2.40 80%
2.50 83%
2.60 87%
2.70 90%
2.80 93%
2.90 97%
3.00 100%
3.10 103%
3.20 107%
3.30 110%
3.40 113%
3.50 117%
3.60 120%
3.70 123%
3.80 127%
3.90 130%
4.00 133%

Attached file