Related:

- If cell contains multiple text then return value
- If cell contains text then return value multiple conditions - Best answers
- If a cell contains a word then - Best answers
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - 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.