Thread: How to get the cell reference of the value selected from name list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YY san.[_2_] YY san.[_2_] is offline
external usenet poster
  
Posts: 27
Default How to get the cell reference of the value selected from name list
Hi,
I have a name list range called Workdays in Sheet2 consists of name range
values A1~A5 = Monday ~ Friday.
In Sheet1, colum A, I have a data validation referring to this list.
If in cell A1, Friday is selected. I want to show "A5" in B2 of Sheet1. Can
anyone help?
Thanks so much for your help.


Reply With QuoteReply With Quote