hlookup help
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 |
hlookup help
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 |
hlookup help
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 |
hlookup help
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 |
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 |
hlookup help
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 |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com