Posted to microsoft.public.excel.programming

aileen

external usenet poster

Posts: 78

IF ISERROR with index match

I am using the following code to find a value in one workbook and return it
to another workbook based on a match between two cells:

Range("I1").Select
ActiveCell.FormulaR1C1 = _

"=INDEX(bloombergsymbols.xlsm!C6,MATCH(RC[-1],bloombergsymbols.xlsm!C10,0))"

I would like to add to the code that IF an error is returned to enter the
value from the H1 cell from the active workbook. Is this possible? I've
tried many different scenarios but I keep getting an object defined error.
Any help is appreciated. Thanks

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
ISERROR and INDEX Funcion question	Flipper	Excel Worksheet Functions	8	March 29th 10 09:29 PM
iserror, index & if	Sueellen1312	Excel Worksheet Functions	4	February 16th 10 05:13 PM
ISERROR,SMALL,INDEX, MATCH, SMALL??	M.A.Tyler	Excel Discussion (Misc queries)	1	May 2nd 07 04:08 AM
IsError and Match function	GDCross	Excel Programming	7	May 26th 06 07:49 PM
IF(ISERROR(MATCH - need value where match was found	Ed[_9_]	Excel Programming	2	November 12th 03 09:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us