1

I want to be able to have a pick list with two columns setup in a worksheet and pick from that list in another worksheet to populate two columns.

Pick List Sheet would look like this

A  Item 1     Item 2
B  Johnson    22
C  Jones      45

Destination Sheet would look like this

A  Item 1  Item 2
B  Drop down to choose Johnson from the pick list, Item 2 is populated with '22'

How could I achieve this?

nixda
  • 27,268
Eric Langley
  • 11

2 Answers2

0

Original question looked more like hlookup, but edited is same, just vlookup Dropdown list is done with Data-Validation.

dest!B2 =vlookup(A2;picksheet!$A$B;2;0)

GoogleDocs demo

Elhana
  • 101
  • 2
-1

=IF(ISNA(VLOOKUP(D14, Sheet2!A:B, 2, 0)), "", VLOOKUP('User Information'!D14, Sheet2!A:B, 2, 0))

This is what worked for me. I know nothing about excel formulas but what Elhana mentioned i wasnt able to use it, may be i was doing something wrong. god knows where this formula came from but it worked.

Ankit
  • 1