How to automatic fill an cell if other cell is some value?

[valioba]

Hi, Guys!

I want to ask, if somebody is able to help me, how can I make automaticly fill one column with values depending from the other column with values, for example if I fill Cell K1 with the value "apple", than automaticly the Cell H1 is filling with the value "peach"?
It needs to work for about 500 rows with different values,.
I guess that first I have to fill the values in some list first in the both columns (H and K), but I do not know where.
Thanks in advance!

[Harribone]

Attached example should be what you're looking for. This uses a VLOOKUP formula, an explanation is on the spreadsheet but there are better explanations out there to help you get a better understanding.

Solution.xlsx

[valioba]

Thanks a lot, Harribone!
That seems to work. I should learn more about VLOOKUP and try to implement it in my tasks.
Thanks again!