Hi, just started new project and reviewing a spreadsheet with nested IF statements which contain vlookup functions in the formula. The vlookup references the cell to be looked up "C6" and the sheet and range are defined "'sheet1'!$A:$H" and the number of columns is defined as "D$1" e.g. (vlookup($C6,'sheet1'!$A:$H,D$1,False).

I don't understand what the "D$1" is contributing to the formula. If someone could explain this I would appreciate it.

Regards,

Davie.