Hi All
I'm trying to do a concatenation based on alternate cell selections.
For example, I have 2 lists in A1: A2 and B1: B2
If I select APPLE in A1 then I select FRUIT in B2 I want a concatenated version of this in A3
However, if change any of the 2 selections, I want the concatenation to also change
Is this even possible? Not even sure how to search for my answer in Google or on here
Thanks for any help
Dan_B
Bookmarks