Need function or macro for the following

hr649

New Member
Joined
May 21, 2014
Messages
8
I have a couple of worksheets. The 1st has drop down menus made up of the items from the 2nd sheet. On that 2nd sheet, each of those items has been assigned a value.

I would to be able to select an item from the drop down menu and have the corresponding value be input in a different cell.

What would be the function or macro to best accomplish this?
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,211
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
INDEX-MATCH or VLOOKUP depending on the layout of data on the 2nd sheet.
 

ChrisBM

Board Regular
Joined
Sep 22, 2014
Messages
215
Don't think you need a macro?

Have data validation in the 1st cell.

Have a match/vlookup function in the second to select from 2nd sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,042
Messages
5,526,420
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top