excel - VBA: How to enter a value according to another value in the same row but different column

Question

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

Answer 1

等待大神答复