stew;392160 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
Check that you have an exact match in Row 1... that there are no extra
spaces, that spelling is the same, etc... also if you are matching
number to number, ensure that both H24 and row 1 are the same format.
--
NBVC
Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile:
http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=109603