# Write text in adjacent cells if one cell value is ___?

Solved/Closed
Related:

- Write text in adjacent cells if one cell value is ___?
- How to write & in laptop - Guide
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum

## 1 response

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549

Jun 13, 2016 at 11:53 AM

Jun 13, 2016 at 11:53 AM

Hi Teaguru,

Try using the VLOOKUP formula. It will let you search for a value (i.e. Black Tea) in a table of information and return a value of a different column.

Write the formula's for 1 row and then drag those down.

Hopefully this makes sense to you. If not, feel free to ask what you need further assistance with.

Best regards,

Towa

Try using the VLOOKUP formula. It will let you search for a value (i.e. Black Tea) in a table of information and return a value of a different column.

Write the formula's for 1 row and then drag those down.

Hopefully this makes sense to you. If not, feel free to ask what you need further assistance with.

Best regards,

Towa

Jun 14, 2016 at 12:38 PM