Related:

- If cell contains text then return value multiple conditions
- If cell contains multiple text then return value - Best answers
- Excel if cell contains word then assign value - Best answers
- If cell contains date then return value ✓ - Office Software Forum
- If a cell has text then return value ✓ - Excel Forum
- Excel - IF function with multiple words ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum

## 1 response

[code]

=IF(LOGIC_TEST,TRUE,FALSE)

/code

So, an example of such would be:

In cell a3 set "=IF(a1="Widget","123","")"

So if you were to put Widget, in cell A1, Cell A3 would have an "123".

You can then NEST if statements, for the other values. Like so:

=IF(a1="Widget","123",if(a1="Sprocket","999",if(a1="Hinge","567","NONE")))

I hope you understand this example.