software

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.

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

quot;cindyquot; wrote:

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

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

nwexcelsolutions.comquot;cindyquot; gt; wrote in message
...
gt;I am trying to lookup a value and get a text response. Is there a problem
gt; using the LOOKUP Function for this? I used this function to return a
gt; numeric
gt; value with no problem.
I am getting #N/A, it is possible that I am not using the correct Function.
The only options for this cell are an quot;Lquot; or an quot;Rquot;.
Here is where I am trying to get the text value from the table below
XYPTM#
Loose Sample Locations:
0.54#VALUE!0.5820
0.82R0.5021
0.66R0.7322
0.06L0.2723
0.03R0.1324

TABLE
0.54R0.5820
0.82R0.5021
0.66R0.7322
0.06L0.2723
0.03R0.1324
0.55R0.2925
0.64L0.7726
0.30R0.5727
0.51R0.6728
0.29R0.0929
0.63R0.8230quot;Toppersquot; wrote:

gt; It should return whatever is in the cell ... what exactly are you getting?
gt;
gt; quot;cindyquot; wrote:
gt;
gt; gt; I am trying to lookup a value and get a text response. Is there a problem
gt; gt; using the LOOKUP Function for this? I used this function to return a numeric
gt; gt; value with no problem.