Glaswegian
01-27-2011, 03:01 AM
Hi
I received help and an excellent formula recently
http://www.vbaexpress.com/forum/showthread.php?t=35730
but I'm looking at a possible re-design of the workbook in question and wondered if it was possible to create a formula based on the following changes.
The dropdowns are still in F16 - F53.
The possible text values are now in a named range on another sheet - the sheet is called 'Tables' and the range Name is 'Answers'.
At the moment, the text answers still matches the row of the dropdown - however, some of the text is duplicated, so that might change.
Thanks .
I received help and an excellent formula recently
http://www.vbaexpress.com/forum/showthread.php?t=35730
but I'm looking at a possible re-design of the workbook in question and wondered if it was possible to create a formula based on the following changes.
The dropdowns are still in F16 - F53.
The possible text values are now in a named range on another sheet - the sheet is called 'Tables' and the range Name is 'Answers'.
At the moment, the text answers still matches the row of the dropdown - however, some of the text is duplicated, so that might change.
Thanks .