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

J

JulieD

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
 
B

Bob Phillips

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

as a guess at what you are asking

--

HTH

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