Hi

Can anyone tell me how you can ref a cell in a vlookup formula for the
lookup_value? I keep getting a #N/A error if I put say B6 but when I input
the actual number that my ref cell B6 holds, say 6, it works.

Thanks