Error in VLOOK UP formula
 

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.

Error in VLOOK UP formula
 

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.

Error in VLOOK UP formula
 

Post the formula
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rajiv" wrote:

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.

Error in VLOOK UP formula
 

And the data and their formats

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike H" wrote in message
...
Post the formula
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rajiv" wrote:

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.