Auto fill

andrisp - Oct 13, 2017 at 02:49 PM
I need some help with excel. For example: I have on Sheet 2, in column A a list of words. So, what i need - if I enter one of the words on sheet 1, column B, I need excel to enter, for exemple the word "car" in column D on sheet 1. So,as an example: On sheet 2, column A i have a list with the words clock, TV ect. And If I inter TV on sheet 1, column B1, I need excel to autofill D1 with the word car.