meng

Posts: n/a

VLookup??

first divide your third column (SeqRange) in two columns with the lower
boundary in column C and the upper boundary in column D

After this use the following array formula (entered with
CTRL+sHIFT+ENTER) on your second sheet:
=MATCH('sheet1'!$B$1:$B$100,MATCH(1,(A1='sheet1'!$ A$1:$A$100)*(B2='she
et1'!$C$1:$C$100)*(B2<='sheet1'!$D$1:$D$100),0))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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	Jeff	Excel Discussion (Misc queries)	2	December 2nd 04 02:40 PM
Need help with modifying VLookUp	Tom	Excel Discussion (Misc queries)	4	December 2nd 04 12:44 AM
Vlookup with VBA	Jeff	Excel Discussion (Misc queries)	8	December 1st 04 02:41 PM
Vlookup returns incorrect match	Smichaud	Excel Discussion (Misc queries)	2	November 30th 04 10:51 AM
Vlookup w/ VB	Jeff	Excel Discussion (Misc queries)	1	November 26th 04 08:39 PM

All times are GMT +1. The time now is 10:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us