Posted to microsoft.public.excel.programming

KK[_8_]

external usenet poster

Posts: 1

Vlookup with multiple FOR condition

Hi,

I have below code for vlookup from different sheets. The problem is the inner loop is not exiting after first condition is met. Like I am getting 3 lookups on the same field (JCell) please help

Set JRng = Sheet2.Range("J8:J10")
Set DRng = Sheet3.Range("D23", Sheet3.Range("D23").End(xlDown))

For Each JCell In JRng.Cells
For Each Dcell In DRng.Cells
JCell.Value = Application.WorksheetFunction.VLookup(Dcell, Sheet4.Range("M:N"), 2, False)
Next Dcell
Next JCell

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 with If condition	Biff	Excel Worksheet Functions	1	March 19th 10 07:01 PM
Two Condition Vlookup	Santi[_2_]	Excel Discussion (Misc queries)	1	March 8th 10 12:01 AM
VLOOKUP Condition	lightbulb	Excel Discussion (Misc queries)	3	June 24th 09 08:36 PM
lookup with multiple condition, but one condition to satisfy is en	Eddy Stan	Excel Worksheet Functions	2	October 27th 07 02:06 PM
vlookup or dget with multiple condition - help please	Eddy Stan	Excel Worksheet Functions	4	September 1st 07 10:22 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us