View Single Post
  #1   Report Post  
KG
 
Posts: n/a
Default 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)??