Lookup values

N

Nordic

I am using lookup to find equivalent values in a row of numbers and totaling
the points. The problem I'm having is that the lookup value is not shifting
to the right of the column and is not being added to my total points column.
How can I resolve this?
Example below:
col. A (points) Col. D(pts) Col. G(lookup value) Col. O
(total pts)
10 (ok) 25(ok) 24(won't shift
to 35
right and isn't
counted in
total)
Thanks for your help,
Nordic
 
Top