hlookup help
Hi
Shouldn't it be C1:DR1? try
=HLOOKUP(Diary!$H$24,'Promoters costs and sales'!C1:DR1,11,0)
You need to make sure that the value in the first row are the same
data type in the dataset below. ie first row = real dates and dataset = real
dates,
otherwise its won't works.
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"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
|