Posted to microsoft.public.excel.programming

Nena[_2_]

external usenet poster

Posts: 20

VLOOKUP

When I try to run this macro I pop box says, "Excel cannot complete
this task with available resources. Choose less data". What am I doing
wrong?

ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC[-5],'Fall 2006 Cohort'!
R2C1:R65536C28,13,FALSE)=TRUE),"""", VLOOKUP(RC[-5],'Fall 2006
Cohort'! R2C1:R65536C28,13,FALSE))"
ActiveCell.Offset(0, 1).Select

Thanks in advance.

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
If (Vlookup 0) working, but what if Vlookup cell does not exist	Steve	Excel Worksheet Functions	18	November 18th 09 07:33 PM
VLookUp - Does the VLookUp return the exact information?	Cpviv	Excel Worksheet Functions	2	October 28th 08 09:57 AM
Vlookup in vlookup - taking the result as array name	SupperDuck	Excel Worksheet Functions	2	June 2nd 07 11:05 AM
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP?	erikhs[_20_]	Excel Programming	1	August 6th 06 06:18 PM
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)	MikeR-Oz	New Users to Excel	1	March 22nd 06 09:01 AM

All times are GMT +1. The time now is 01:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us