Trying to find corresponding value on a table/chart

[Maverick3176]

Ok....not sure how to describe this perfectly, but here goes.

On sheet #1 cell H4 I have a certain number value % that is determined off of info on that sheet.

On sheet #2 I have a table Column C7-C27 has a set of point values 0-20. D7-D27 are a list of percentages corresponding to the values Creating a range

Example
C D
0 0%
1 6%
2 12%
3 17%
4 23%
5 29%
6 35%
7 41%
8 47%

etc...
19 96%
20 100%

On sheet 1 H4 the value is for example 28%. What do I need to put in H5 so it can show the corresponding value in column C of the chart(in this case it would be 4).

I hope this makes sense. Any help would be greatly appreciated. :-)

[Special-K]

Try

=OFFSET(C7,MATCH(LOOKUP(H4,Sheet2!C7:D27),C7:D27)-1,0)

The LOOKUP returns the nearest value without going over in this case 28% so it returns 23%
The MATCH returns the row number in column D
The OFFSET returns the content of cell pertaining to that row

[Maverick3176]

Thanks...I have the file at work. I will be trying it out then and let you know how it works. Thanks for the quick feedback. This site is awesome

[Maverick3176]

ok..that did not work. Does anyone else have any ideas

[FDibbins]

can you upload a sample file so we can see the context/layout etc of your data?

[Cutter]

Try

=LOOKUP(H4,Sheet2!D7:D27,Sheet2!C7:C27)