Nesting If and Vlookup

S

sferguson

I am trying to write a formula that will say if my vlookup returns an error i
want it to show Not Taken, but if my vlookup does not return and error I want
it to show the response request from column 6.

Any help would be appreciated. Thanks!
 
B

Bernard Liengme

I will assume you have a working VLOOKUP formula
=IF(ISNA(your-formula),"Not Taken", your-formula)

If you are using Excel 2007 have a look as IFERROR
=IFERROR(your-formula, "Not Taken")
best wishes
 

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

Top