vlookup return blank

hi.

how can I make this formula to return to blank instead of #n/a.

"=VLOOKUP(RC[-8],'[case number.xls]Sheet1'!C2:C3,2,0)"


any help is appreciated.

=iferror(VLOOKUP(RC[-8],'[case number.xls]Sheet1'!C2:C3,2,0),"")

running into error when i run in Marco.

Originally Posted by YasserKhalil

=iferror(VLOOKUP(RC[-8],'[case number.xls]Sheet1'!C2:C3,2,0),"")

it is running into error in Macro

When using formulas in vba it should be like that

=iferror(VLOOKUP(RC[-8],'[case number.xls]Sheet1'!C2:C3,2,0),"""")

Originally Posted by YasserKhalil

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]

Can you post your sample workbook?

Originally Posted by YasserKhalil

Can you post your sample workbook?

I wrote the new macro with your formula, and it works now.
thanks alot.