lookup function

[cindy]

I am trying to lookup a value and get a text response. Is there a problem
using the LOOKUP Function for this? I used this function to return a numeric
value with no problem.

 

[Toppers]

It should return whatever is in the cell ... what exactly are you getting?

 

[Peo Sjoblom]

Note that the values need to be sorted in ascending order (a-z, -1,0,1,2 for
numbers) in the lookup vector, if not you will get wrong results

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[cindy]

I am getting #N/A, it is possible that I am not using the correct Function.
The only options for this cell are an "L" or an "R".
Here is where I am trying to get the text value from the table below
X Y PTM#
Loose Sample Locations:
0.54 #VALUE! 0.58 20
0.82 R 0.50 21
0.66 R 0.73 22
0.06 L 0.27 23
0.03 R 0.13 24

TABLE
0.54 R 0.58 20
0.82 R 0.50 21
0.66 R 0.73 22
0.06 L 0.27 23
0.03 R 0.13 24
0.55 R 0.29 25
0.64 L 0.77 26
0.30 R 0.57 27
0.51 R 0.67 28
0.29 R 0.09 29
0.63 R 0.82 30