| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#value returned instead of data
My formula:
=IF(ISERROR(MATCH(K494,WWP_Installs!C$2:C$490,0)), "Unk",WWP_Installs!K$2:K$490) K494 = 1980A 18th AVE NE WWP_Installs!C$2:C$490 = 1980A 18th AVE NE WWP_Installs!K$2:K$490 = 256M/64K But result of formula is #VALUE when performing calculationsteps, it say the cell (K494) contains a constant. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| This query returned no data | Excel Worksheet Functions | |||
| Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Threaded Mode
