Formula or Argument in excel

Closed

ctrotter43 Posts 2 Registration date Saturday February 27, 2010 Status Member Last seen February 28, 2010 - Feb 27, 2010 at 01:38 AM
ctrotter43 Posts 2 Registration date Saturday February 27, 2010 Status Member Last seen February 28, 2010 - Feb 28, 2010 at 04:01 AM

Hello,

I am looking for a formula to use so that when i pick a person's name from the drop down list a date will appear in the cell next to the name picked from the drop down list. The date to be entered comes from the Master date in cell A26. If no name is in the drop down list then their is to be no date in this cell.

Chris

Formula or Argument in excel
Number to words in excel formula - Guide
Excel grade formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Gif in excel - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 27, 2010 at 08:47 AM

There is no formula for that

You have to use

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

see this that had pretty much same idea. In fact your is far simpler

https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007

ctrotter43 Posts 2 Registration date Saturday February 27, 2010 Status Member Last seen February 28, 2010
Feb 28, 2010 at 04:01 AM

Thanks for this information

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Percentage Work

Similar discussions

Subscribe To Our Newsletter!