| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical test for an #N/A condition in a cell
Thank you very much!
"Laura Cook" wrote: To test for #N/A, you can use "ISNA": =IF(ISNA(VLOOKUP(A1,Sheet2!B1:C20,2,0)),0,VLOOKUP( A1,Sheet2!B1:C20,2,0)) Laura "F.Rosario" wrote in message ... I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical test if cell uses formatting.. | Excel Worksheet Functions | |||
| IF functionality, Logical Test = Nonbalnk Cell | Excel Worksheet Functions | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| =IF logical test to search only part of a cell | Excel Worksheet Functions | |||
![F.Rosario[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
