Related:

- Excel if cell contains word then assign value
- If cell contains multiple text then return value - Best answers
- If a cell contains a word then - Best answers
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
- Word free for u - Guide
- Count if cell contains number - Excel Forum

## 1 reply

[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.