Find multi intervals for a datapoint from scatter chart than mark it which mark is related to the interval.

[Lollek]

Hello</SPAN></SPAN>

I need your help! I have Excel 2010.</SPAN></SPAN>

I wish to group my values into intervals than I want to add a mark which later discribe the position of the value.</SPAN></SPAN>
I have two values in %. The 1st is from the Low Yld and the 2nd from the top yield environment. Both are discribe the % of the average of cheks.</SPAN></SPAN>
I have the % calculations but now I want to supplement my database with a new column which collects the marks. For this I need a formula which are selecting the right intervals than pull a mark from the reference table. The intervals border are in the table below and in the picture. </SPAN></SPAN>

[TABLE="width: 768"]
<TBODY>[TR]
[TD]Sample:</SPAN>
[/TD]
[TD]Entry</SPAN>
[/TD]
[TD]Low YLd </SPAN>
[/TD]
[TD]Top Yld</SPAN>
[/TD]
[TD]Mark</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Reference table:</SPAN>
[/TD]
[TD]x axis Low YLd </SPAN></SPAN>
[/TD]
[TD]y axis Top Yld</SPAN>
[/TD]
[TD]Mark</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A</SPAN>
[/TD]
[TD]120.3</SPAN>
[/TD]
[TD]102.9</SPAN>
[/TD]
[TD]A(**)</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]104<</SPAN></SPAN>
[/TD]
[TD]104<</SPAN></SPAN>
[/TD]
[TD]A(***)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B</SPAN>
[/TD]
[TD]119.7</SPAN>
[/TD]
[TD]101.8</SPAN>
[/TD]
[TD]A(*)</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]102-104</SPAN></SPAN>
[/TD]
[TD]102-104</SPAN></SPAN>
[/TD]
[TD]A(**)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C</SPAN>
[/TD]
[TD]108.4</SPAN>
[/TD]
[TD]103.6</SPAN>
[/TD]
[TD]A(**)</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]99-102</SPAN></SPAN>
[/TD]
[TD]99-102</SPAN></SPAN>
[/TD]
[TD]A(*)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D</SPAN>
[/TD]
[TD]110.1</SPAN>
[/TD]
[TD]103.1</SPAN>
[/TD]
[TD]A(**)</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]90-99</SPAN></SPAN>
[/TD]
[TD]106<</SPAN></SPAN>
[/TD]
[TD]I(***)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E</SPAN>
[/TD]
[TD]99.5</SPAN>
[/TD]
[TD]105.1</SPAN>
[/TD]
[TD]A(*)</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]85-90</SPAN></SPAN>
[/TD]
[TD]104.5-106</SPAN></SPAN>
[/TD]
[TD]I(**)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]F</SPAN>
[/TD]
[TD]89.8</SPAN>
[/TD]
[TD]106.9</SPAN>
[/TD]
[TD]I(***)</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]80-85</SPAN></SPAN>
[/TD]
[TD]103-104.5</SPAN></SPAN>
[/TD]
[TD]I(*)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]G</SPAN>
[/TD]
[TD]87.0</SPAN>
[/TD]
[TD]95.0</SPAN>
[/TD]
[TD]XXXX</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]114<</SPAN></SPAN>
[/TD]
[TD]97.7-99</SPAN></SPAN>
[/TD]
[TD]R(***)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]....</SPAN>
[/TD]
[TD]93.7</SPAN>
[/TD]
[TD]105.0</SPAN>
[/TD]
[TD]....</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]109-114</SPAN></SPAN>
[/TD]
[TD]96.5-97.7</SPAN></SPAN>
[/TD]
[TD]R(**)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]95.2</SPAN>
[/TD]
[TD]104.5</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]106-109</SPAN></SPAN>
[/TD]
[TD]95.5-96.5</SPAN></SPAN>
[/TD]
[TD]R(*)</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]119.6</SPAN>
[/TD]
[TD]99.2</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]not in any interval</SPAN></SPAN>
[/TD]
[TD]not in any interval</SPAN></SPAN>
[/TD]
[TD]XXXX</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]111.6</SPAN>
[/TD]
[TD]100.7</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]...
[/TD]
[TD]...
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

​

http://kepfeltoltes.hu/140505/diagram_www.kepfeltoltes.hu_.png
Thanks in advance</SPAN></SPAN>

lollek</SPAN></SPAN>