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.

Please Login or Register  to view this content.

running into error when i run in Marco.

Originally Posted by YasserKhalil

Please Login or Register  to view this content.

it is running into error in Macro

When using formulas in vba it should be like that

Please Login or Register  to view this content.

Originally Posted by YasserKhalil

When using formulas in vba it should be like that

Please Login or Register  to view this content.

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.