Quote Originally Posted by YasserKhalil View Post
When using formulas in vba it should be like that
=iferror(VLOOKUP(RC[-8],'[case number.xls]Sheet1'!C2:C3,2,0),"""")
still getting an error: RC[-8]