I was reviewing a formula developed by a fellow employee and cannot figure
out WHY it works.

=(range1)*0.1

facts:
range1 refers to sheet1!$g$2:$g$27
dates in sheet1!b2:b27 are the same as sheet2!b2:b27
formula above is in sheet2 cells c2 to c27

Why does the formula know to bring the value in range1 for the same date? I
have rechecked and 1) the name range1 refers to a single column array of
values and does not include the date and 2) the formual is not entered as an
array formula.

Thanks.

Mike