| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 4030 | 2000-04-15 06:30:00 | Excel #n/a values | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 4492 | 2000-04-15 06:30:00 | I am using MATCH function to look up a list value. The value I am seeking is not always present in the columnar array, and MATCH returns an #N/A Value. I need to be able to extract the real values for calculation purposes, and leave the #N/A out. I have tried the ERROR.TYPE function, but it returns a further #N/A response if the Error.Type is not an 'Error' but a real value. Any ideas? |
Guest (0) | ||
| 1 | |||||