Posted to microsoft.public.excel.misc

Mac[_3_]

external usenet poster

Posts: 9

Vlookup to the left?

=Vlookup(a1,Range,6,FALSE)

Vlookup will count 6 column to the right and grab the value. Can I use
Vlookup to count to the left something like -6?

Thanks,
mac

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
'RIGHT', 'LEFT' in a VLOOKUP	RJB	Excel Discussion (Misc queries)	6	March 14th 08 12:05 PM
vlookup left	Mottyb	Excel Worksheet Functions	2	November 22nd 07 07:58 PM
VLOOKUP LEFT VS RIGHT	Jerry[_2_]	Excel Worksheet Functions	2	September 7th 07 03:40 PM
Vlookup to the left	comparini3000	Excel Worksheet Functions	4	June 23rd 06 09:22 PM
VLOOKUP Left Value	jim	Excel Discussion (Misc queries)	4	June 5th 06 05:15 PM

All times are GMT +1. The time now is 05:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us