how do I write a vlookup function within an iserror function so t.
 

Hi

please post a short description in the subject line and the question in the
message body as it gets truncated in the subject line
taking a guess as to what you're after try
=IF(ISNA(VLOOKUP(the formula)),"",VLOOKUP(the formula))

however please post back if this isn't what you're after
Cheers
julieD

"JBLeeds" wrote in message
...

=IF(ISERROR(VLOOUP...),"",VLOOKUP...)

as a guess at what you are asking

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JBLeeds" wrote in message
...