Lookup Problem
 

I'm not sure why Lookup isn't returning the correct values. I have the
following Lookup table:

G J

17 AOI 0.00%
18 NCO 6.07%
19 ARM 7.83%
20 TCT 17.00%

With my function arguments listed as follows:
F G
63 AOI =LOOKUP(F63,G$17:G$20,J$17:J$20)
64 NCO =LOOKUP(F64,G$17:G$20,J$17:J$20)
65 ARM =LOOKUP(F65,G$17:G$20,J$17:J$20)
66 TCT =LOOKUP(F66,G$17:G$20,J$17:J$20)

Most return the correct value except ARM. ARM is picking up AOI's value of
0.00% instead of 7.83%. I've checked the format of the cells and even used
the values in my lookup table to cut and paste into the arguments so that I
could make sure there were no leading/trailing spaces etc. Any suggestions?

Hi
use
=VLOOKUP(F63,G$17:J$204,0)

--
Regards
Frank Kabel
Frankfurt, Germany
"StephanieH" schrieb im Newsbeitrag
...
I'm not sure why Lookup isn't returning the correct values. I have the
following Lookup table:

G J

17 AOI 0.00%
18 NCO 6.07%
19 ARM 7.83%
20 TCT 17.00%

With my function arguments listed as follows:
F G
63 AOI =LOOKUP(F63,G$17:G$20,J$17:J$20)
64 NCO =LOOKUP(F64,G$17:G$20,J$17:J$20)
65 ARM =LOOKUP(F65,G$17:G$20,J$17:J$20)
66 TCT =LOOKUP(F66,G$17:G$20,J$17:J$20)

Most return the correct value except ARM. ARM is picking up AOI's value
of
0.00% instead of 7.83%. I've checked the format of the cells and even
used
the values in my lookup table to cut and paste into the arguments so that
I
could make sure there were no leading/trailing spaces etc. Any
suggestions?