I am having massive amounts of trouble with the =Lookup function. Here is the
formula that I'm using

=LOOKUP(A1,B1:B20,C1:C20)

The formula should find A1 within B1:B20, and then reference the the cell
just below it. So, A1=JJ and B13=JJ and C13=13. C20=20, and the Lookup
function keeps giving me 20! All the cells in B1:B20 are formulas, so I
think this is messing the formula up because when I don't use a formula in
B1:B20, the Lookup shows 13 (the correct #).

Please help! Thank you!