Posted to microsoft.public.excel.programming

Haldun Alay[_2_] Haldun Alay[_2_] is offline

external usenet poster

Posts: 16

VLOOKUP Question

Hi,

I'm using VLOOKUP function to get some values from a range. The problem is
if source range has more than one record for the condition, VLOOKUP always
gets first occurance. Is there anyway to get second or third occurance of
lookup value.

Thanks in advance

Haldun

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 question	aimlessmn	Excel Discussion (Misc queries)	2	April 10th 09 09:49 PM
Vlookup question	zot	Excel Worksheet Functions	2	March 17th 09 09:08 PM
VLOOKUP question	duration	Excel Worksheet Functions	9	July 11th 06 03:25 PM
VLOOKUP question	Watercolor artist	Excel Worksheet Functions	1	June 13th 05 08:15 PM
VLOOKUP question	Pierre Fichaud	Excel Worksheet Functions	5	March 18th 05 10:53 PM

All times are GMT +1. The time now is 11:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us