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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vLookup and Line Breaking 0
If statement with Vlookup - including ISNA function to compare two columns from different worksheets 4
modifying T. Valko ws function 5
VLookup IF word in string exists within cell, use the word. 0
How do I make the fill color of a cell on one sheet follow the co. 1
How do I write an If(And( function using dates as my logical test? 4
How do I write a VLOOKUP function that returns 0's, not neg vals? 4
vLookup with comma break 0

Top