Write text in adjacent cells if one cell value is ___?
Solved/Closed
Related:
- Write text in adjacent cells if one cell value is ___?
- Merge adjacent cells in columns with same data/value in excel - Forum - Excel
- Cell input to call macro in adjacent cell - How-To - Excel
- Excel write value to another cell - Guide
- How to write in the same cell in excel - Guide
- Place specfic text in cell based on text in an adjacent cell ✓ - Forum - Excel
1 reply
TrowaD
Jun 13, 2016 at 11:53 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
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