We can't help you until you post your formula.

Regards,
Fred

"Rajiv" wrote in message
...
when i am using vlookup formula, i getting 2 types of error (result) like
#N/A or #REF!. while i fill applicable data in formula. Please help me on
these error.