I have a dropdown in sheet 1 which has the values "cat","dog", and "horse". On selection of a value, I want it to take the adjacent column as a key and search on it in another sheet and write the corresponding value next to it. For example:
This is sheet 1. Upon selection of "Cat" in A1
, it takes the value of adjoining column i.e., "house1" and in sheet 2, a search is done for "house1" and in the adjoining column animal, the value "Cat" is written.