I must be missing something when it comes to vlookup. I have the formula
below which references a cell (AZ21) on the worksheet and compares the
value in that cell to the table on the Codes worksheet. In this example
AZ21 = 6 and the returned value I am looking for is P. What I get is R. Can
someone tell me where I have gone wrong?


VLOOKUP(AZ21,Codes!$B$8:$C$21,2)

B C
8 2 R
9 12 RT
10 6 P
11 16 POT
12 40 R
13 50 R
14 51 R
15 35 R
16 60 R
17 70 0
18 78 0
19
20
21