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