confused by COLUMN worksheet function
I have seen a worksheet containing the following VLOOKUP formula:
=VLOOKUP($C$27,$C$63:$N$82,COLUMN(B1))
This is a lookup table for discount factors, column C listing the discount
rates in % starting at C63. What is the purpose/result of using COLUMN(B1)??
|