I have values being imported from a weather station, I have all values displaying like I want except wind direction. It is reported as degrees on a compass and I would like it to display N, NE, E...etc. I have the value ranges figured, but the formula has me stumped. Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Show text for a value range
- Thread starter tbell
- Start date
Special-K99
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 8,521
- Office Version
- 2019
Try
=LOOKUP(A1,{0,45,90,135,180,225,270,315},{"N","NE","E","SE","S","SW","W","NW"})
=LOOKUP(A1,{0,45,90,135,180,225,270,315},{"N","NE","E","SE","S","SW","W","NW"})
Upvote
0
wolverineb
Well-known Member
- Joined
- Jan 26, 2005
- Messages
- 690
Or if you want a table you could do this:
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; 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;" /><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 >G</td><td >H</td><td >I</td><td >J</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Degrees</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Direction</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Input</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Output</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">0</td><td >N</td><td style="text-align:right; ">230</td><td >W</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">45</td><td >E</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">135</td><td >S</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">225</td><td >W</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">315</td><td >N</td><td > </td><td > </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 >J3</td><td >=VLOOKUP(I3,G3:H7,2,1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; 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;" /><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 >G</td><td >H</td><td >I</td><td >J</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Degrees</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Direction</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Input</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Output</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">0</td><td >N</td><td style="text-align:right; ">230</td><td >W</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">45</td><td >E</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">135</td><td >S</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">225</td><td >W</td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">315</td><td >N</td><td > </td><td > </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 >J3</td><td >=VLOOKUP(I3,G3:H7,2,1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4
Upvote
0
Similar threads
- Question
- Solved
