Thread: Lookup Problem
View Single Post
  #1   Report Post  
StephanieH
 
Posts: n/a
Default 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?