Lookup Problem

[dickpierce]

Hello!

I have a simple lookup problem. I tried using the Lookup function but because my data is not in the correct order, I'm getting wonky results.

Here's my data.

In A2:A4, I have A,B,C
In B2:B4, I have 5,8,3
In B5, I have 8
In B6, I would like to look up the number in B5, and have the result be the letter in A3, or B.
I would copy the formula down in column 6, so as to when I go to my data in C2:C4, for example I have 6 1 3, C5 would be the Max of C2:C4 or 6, and the result in C6 would be A.

Thanks in advance.

 

[VoG]

Like this?

<b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >A</td><td style="text-align:right; ">5</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >B</td><td style="text-align:right; ">8</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >C</td><td style="text-align:right; ">3</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td >B</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B5</td><td >=INDEX(A2:A4,MATCH<span style=' color:008000; '>(MAX<span style=' color:#0000ff; '>(B2:B4)</span>,B2:B4,0)</span>)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[Jonmo1]

Try this

=INDEX($A$2:$A$4,MATCH(B5,B$2:B$4,0))

Hope that helps..

 

[dickpierce]

Thanks! That works great.