macro for a range of values

[cuzza_fin]

hi all,
i want to write a macro for the following:
- where does value in cell x fall within a specified range (Range of values and text.xlsx) and assign the appropriate text value.

An example, a value of 168.75 = W; a value of 168.749 = WNW

I could write a rather large series of IF functions but this seems rather labour intensive so I am hoping someone here can provide an easier solution?

Best regards,
Michael

[:) Sixthsense :)]

An example, a value of 168.75 = W; a value of 168.749 = WNW

Really I am unable to understand the logic from the above example

[cuzza_fin]

Maybe this will help. For the the values below, 168.75 is the middle value between true east (E) and east-north-east (ENE) and so on...
Number Text
-180 E
-168.75
-157.5 ENE
-146.25
-135 NE

[alansidman]

I would suggest you build a table of values and directions. Then use VLookup to evaluate where your data lies in the table. As a point of interest, I always thought that 180 degrees was due south and 90 degrees was due east.

[Sean Thomas]

Try this in a cell

Please Login or Register  to view this content.

E2 being the cell with the value you are looking for.
It will give you the closest match for those that have no text value

[cuzza_fin]

nice work alansidman and sean, I rarely use vlookup, thanks again.
re alansidman: you are correct re angle and direction but for the angles generated in arcgis I am after the opposite direction and switching them around is the easiest solution