Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If you have the dropdown items in Column A of Sheet2, then add this formula in Column B of Sheet2.

=HLOOKUP(A1,Sheet1.A3:A5,3,0)