Posted to microsoft.public.excel.misc

SteW

external usenet poster

Posts: 293

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hlookup?	Lscrivener	Excel Discussion (Misc queries)	2	January 27th 08 10:23 PM
help with hlookup	Cam1234	Excel Discussion (Misc queries)	1	November 27th 07 12:31 AM
Hlookup	Duplatt	New Users to Excel	11	November 9th 07 03:05 PM
HLookUp	David Mok	Excel Worksheet Functions	1	August 24th 07 08:50 PM
Hlookup	lmullenjr	Excel Discussion (Misc queries)	3	August 18th 06 07:15 PM

All times are GMT +1. The time now is 12:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us