| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return value other than #N/A
I have a spreadsheet utilizing a VLOOKUP- VLOOKUP(A1,Tariff,4,false). Upon
the false lookup, the formula returns #N/A, and a true lookup returns a dollar amount. In the next column, I want to put a value based on the VLOOKUP return, and if it is #N/A to put a blank. I cannot seem to get any valuse returned in the second column other than #N/A if a false lookup occurs. Does anyone know how I do this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return value other than #N/A
=IF(ISNA(vlookupformula,"",vlookupformula))
Gord Dibben MS Excel MVP On Tue, 04 Apr 2006 22:30:43 GMT, "mtbrindamour via OfficeKB.com" <u11944@uwe wrote: I have a spreadsheet utilizing a VLOOKUP- VLOOKUP(A1,Tariff,4,false). Upon the false lookup, the formula returns #N/A, and a true lookup returns a dollar amount. In the next column, I want to put a value based on the VLOOKUP return, and if it is #N/A to put a blank. I cannot seem to get any valuse returned in the second column other than #N/A if a false lookup occurs. Does anyone know how I do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return value other than #N/A
This formula in some cell will give a blank cell if A1 has an error, and
will give what's in A1 if not. HTH Otto =IF(ISERROR(A1),"",A1) "mtbrindamour via OfficeKB.com" <u11944@uwe wrote in message news:5e4b19e4700b2@uwe... I have a spreadsheet utilizing a VLOOKUP- VLOOKUP(A1,Tariff,4,false). Upon the false lookup, the formula returns #N/A, and a true lookup returns a dollar amount. In the next column, I want to put a value based on the VLOOKUP return, and if it is #N/A to put a blank. I cannot seem to get any valuse returned in the second column other than #N/A if a false lookup occurs. Does anyone know how I do this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Hybrid Mode
