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.

  • 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 '17 at 7:19
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))
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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