| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 7371 | 2001-01-19 06:22:00 | Excel Function question | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 8081 | 2001-01-19 06:22:00 | I need to ask the question - Is this cell's data the same as the data in any of this range? For example, is B2 equal to anything in D3:D10? I need this in an IF function, something like... =IF(B2=(J2:J8),'Yes','No') except B2=(J2:J8) just compares B2 to J2 Any thoughts would be magic! |
Guest (0) | ||
| 1 | |||||