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

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

You ment C1:DR1, didn't you!
=HLOOKUP(Diary!$H$24,'Promoters costs and sales'!C1:DR1,11,0)
Regards,
Stefi

€žstew€� ezt Ã*rta:

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

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

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

Francis;392214 Wrote:
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

If it is indeed HLOOKUP the OP is wanting, then the original formula is
correct... it looks up values in C1:DR1 and returns what is in C11:DR11
of corresponding column...


--
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