Can you please help me figure out what is the way to enter a value to a cell in one column according to a value in a different column but the same row?
let's say I don't know where is the column but I do know what is the Header name and I know how to find it and declare it as a range.
- Input:
Fruit | Color |
---|---|
Banana | |
Kiwi | |
Watermelon |