Posted to microsoft.public.excel.programming

geb

external usenet poster

Posts: 19

HLookUp

I want to use the hlookup function but the data I need to look up
has the lookup value at the bottom row rather than the top.

(Find a match in the bottom row and return the values in the same column
for the 10 rows above the lookup value).

Can this be done?

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 help	pm	Excel Discussion (Misc queries)	6	September 10th 08 12:31 AM
V+HLookup?	Susan	Excel Discussion (Misc queries)	3	June 22nd 07 06:20 PM
hlookup & ?	Intermediate Excel User....	Excel Worksheet Functions	4	September 1st 06 12:50 PM
hlookup	tikchye_oldLearner57	Excel Discussion (Misc queries)	4	August 24th 06 12:46 PM
Hlookup	lmullenjr	Excel Discussion (Misc queries)	3	August 18th 06 07:15 PM

All times are GMT +1. The time now is 01:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us