Add Value to Column Based on Another Column

[Cooker83]

Hi all,
I have a question that's a little hard to explain.. I have 2 cells, A1 and A2 and also a table C1:D4. I want to use formulas, no VBA/macro, to input a value from the table into A3. Let me give an example..

[TABLE="class: grid, width: 200"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]24
[/TD]
[TD][/TD]
[TD]w
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD]x
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]y
[/TD]
[TD]11
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]z
[/TD]
[TD]16
[/TD]
[/TR]
</TBODY>[/TABLE]

I want A3 to figure out that A1/A2 equals 8 AND also return a value from column C that is larger than my A1/A2 value. So in A3, I want 'y' to show up. Now if I change A1 to 36 I would want A3 to show me 'z'.
Thanks for looking,
Greg

 

[kevatarvind]

Hi And Welcome To The MR Excel Board

Try Below ( Formula Must confirm With ( CTRL + SHIFT + ENTER) other wise it will not work)
Formula A3 =INDEX(C1:C4,MATCH(TRUE,D1:D4>A1/A2,0)) See below

Excel Workbook
	A	B	C	D
1	24		w	1
2	3		x	8
3	y		y	11
4			z	16
Sheet1