Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting If and Vlookup
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting If and Vlookup
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "sferguson" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
nesting within vlookup | Excel Worksheet Functions | |||
Nesting VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
Nesting VLOOKUP functions | Excel Worksheet Functions | |||
nesting if > 7 or using hlookups in a vlookup | Excel Worksheet Functions |