S
StephanieH
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?
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?