Hi all,
I got given this formula on a forum and I was very grateful as it works perfectly, however there is one part of it that I don't understand. The formula is:
=IFERROR((INDEX($C$7:$I$29,MATCH($A34,$A$7:$A$29,0),COLUMN(A:A))*'bed size 1a'!J14*52/1000),"").
The bit I don't understand is the COLUMN(A:A), as the information it is regarding is not in column A, and when this piece of the formula is removed the formula still works exactly the same.
Thanks
Bookmarks