Hi
In a data validation list can I club properties of 2 different cell input values in a single cell.
Attached is a sheet which may elaborate my actual requirement.
Thanks for the help offered.
Pal
Hi pal_slg
Q2
you cant use union in validation list but you can combine the two selection in another helper column and use it for the validation list
=INDIRECT(J$2,ROW()) & " " & INDIRECT(K$2,ROW())
fill down
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
better still because the arrays arnt the same size
=IFERROR(INDIRECT(J$2,ROW()) & " " & INDIRECT(K$2,ROW()),"")
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks