# 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 ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

## 1 response

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552

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