1

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.

1
  • Eg: When I select "Cat" option in the drop-down list of A1 in sheet 1, it should write "Cat" in B2 of Sheet 2 using the "house1" as the key to write it there.
    – Pixel92283
    Oct 24, 2017 at 7:19

1 Answer 1

0

When I select "Cat" option in the drop-down list of A1 in sheet 1, it should write "Cat" in B2 of Sheet 2 using the "house1" as the key to write it there.

Sheet2!B2:

=ARRAYFORMULA(VLOOKUP(A2:A4,{Sheet1!B1:B3,Sheet1!A1:A3},2,0))
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.