Validaation List
Hi
I have a spreadsheet with a list of Client Names in it. Column B Has their First name and Column C has there surname Column D has there Postal area. I want to be able to have a drop down list that shows there complete name and Postal Area. Is this possible?? Thanks |
Validaation List
Concatenate the cells in the next column and do the dropdown list off that column. Use something like this =A2& " "&B2& " "&C2 in cell D2 say. -- PowerWheels ------------------------------------------------------------------------ PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045 View this thread: http://www.excelforum.com/showthread...hreadid=498600 |
Validaation List
Hi!
You'd have to use a helper column where you concatenate the names and post codes: Assume the range of names and codes are in B1:D10. In E1 enter this formula and copy down to E10: =B1&" "&C1&" "&D1 Then, as the source for the drop down: =$E$1:$E$10 Biff Then use column E as the source for the drop down. "Andrew C" wrote in message ... Hi I have a spreadsheet with a list of Client Names in it. Column B Has their First name and Column C has there surname Column D has there Postal area. I want to be able to have a drop down list that shows there complete name and Postal Area. Is this possible?? Thanks |
Validaation List
Thanks Guys.
It works Great "Andrew C" wrote: Hi I have a spreadsheet with a list of Client Names in it. Column B Has their First name and Column C has there surname Column D has there Postal area. I want to be able to have a drop down list that shows there complete name and Postal Area. Is this possible?? Thanks |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com