The lookup date should be available in the 1st row of the array. Are you sure
the lookupdate is available in row1 (C1:DR1)

If this post helps click Yes
---------------
Jacob Skaria


"stew" wrote:

Hi All

What is wrong with the following formula
=HLOOKUP(Diary!$H$24,'Promoters costs and sales'!C1:DR11,11,0)

Its function is to use the date in Diary!H24, look for that date in
worksheet 'Promoters costs and sales'! range C1 Thru DR11 and when it finds
return the number in row 11

All help gratfully received

Thanks

Stew