Posted to microsoft.public.excel.misc

boardbug

external usenet poster

Posts: 2

Offset VLOOKUP results

VLookup returns a value in the same row. However, for my purposes I need the
value in a row ahead or a row behind.

So for example if Vlookup formula returns a value in Cell b3, I actually
want to know what it's in the next row i.e. Cell b4 or possibly Cell b2
Does anyone have any thoughts??

Thank you!

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
VLOOKUP and OFFSET	CEG	Excel Worksheet Functions	3	September 8th 08 07:16 PM
offset within vlookup	jchick0909	Excel Discussion (Misc queries)	6	October 19th 07 08:55 PM
offset off a vlookup?	txm49	Excel Discussion (Misc queries)	5	October 11th 07 04:10 PM
VLOOKUP and OFFSET	PJ	Excel Worksheet Functions	2	July 18th 07 03:28 PM
Vlookup is not enough ... can OFFSET be used ?	Brian Ferris	Excel Worksheet Functions	9	October 31st 05 02:36 PM

All times are GMT +1. The time now is 12:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us