Posted to microsoft.public.excel.programming

Steve[_4_] Steve[_4_] is offline

external usenet poster

Posts: 184

Odd Lookup Formula

Hi. Can I write a formula that will scan all fo Sheet2, with a lookup
value in cell Sheet1!A1, and return the value in the cell that is 8
rows directly below the cell where the lookup value is found?

Thanks!

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
Utilizing a RANDBETWEEN() formula within a LOOKUP formula	Rich Werk.	Excel Discussion (Misc queries)	4	November 4th 09 03:01 AM
Lookup Formula	Kaye	Excel Discussion (Misc queries)	2	August 4th 08 09:26 PM
Lookup formula	Frances C[_2_]	Excel Discussion (Misc queries)	2	September 29th 07 07:32 PM
Need a lookup formula	Scorpvin	Excel Discussion (Misc queries)	3	August 17th 06 02:24 PM
Lookup Formula - but have a formula if it can't find/match a value	Stephen	Excel Worksheet Functions	11	June 14th 05 05:32 AM

All times are GMT +1. The time now is 04:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us