M
Matin D HJE
I am using Excel 2003. Using the following data table (part ncluded) I am
using Vlookup to look up a corrction value for 'A' in cell b3 based on the
table relating to 'A'-0.1. Formula used for cell b4
=VLOOKUP(B3-0.1,A7:AB20,2,FALSE)
Par t table : A7 = 0.00 and increments by 0.01 to 0.13 in A20. Corresponding
values in column B are B7=0.00, b8=0.02, b9=0.04,b10=0.06, b11=0.07,
b12=0.08, b13=0.09, b14=0.11.b15=.012,b6=0.13,b17=0.14, b18=0.15, b19=0.17 &
b20=0.18
The formula seems to work for some values of 'A' in the range but returns
#N/a for others. Cell formats all set to number.
Advice welcomed please
using Vlookup to look up a corrction value for 'A' in cell b3 based on the
table relating to 'A'-0.1. Formula used for cell b4
=VLOOKUP(B3-0.1,A7:AB20,2,FALSE)
Par t table : A7 = 0.00 and increments by 0.01 to 0.13 in A20. Corresponding
values in column B are B7=0.00, b8=0.02, b9=0.04,b10=0.06, b11=0.07,
b12=0.08, b13=0.09, b14=0.11.b15=.012,b6=0.13,b17=0.14, b18=0.15, b19=0.17 &
b20=0.18
The formula seems to work for some values of 'A' in the range but returns
#N/a for others. Cell formats all set to number.
Advice welcomed please