Constructing sentences using fields (database-like)

[Trotters]

Hi.

Normally, I have a rough idea where to start with these sorts of things but this one has me beat.

For a real estate office, I have to come up with a way of constructing multiple variations of a sentence from pre-defined fields.

Example:
Screen Shot 2016-11-02 at 4.15.11 PM.png

The exact fields will be given to me later and I have the property addresses broken up by street number/name and suburb.

So I need excel to extract every conceivable sentence using those fields (the results can be spat out into another cell or multiple cells on another sheet)

Examples:
1. Your house at address 1 is ready for inspection
2. Your house at address 1 is awaiting pest control
3. Your apartment at address 5 is ready for inspection
4. Your land at address 3 has been approved for development

Etc and so on.

I realise the total number of permutations in that little lot equals 4^3 (64) and there are hundreds of properties to add in. It has been explained WHY they need this but I still don't get it. I'm just the monkey, not the organ-grinder.

I've been struggling with this for a week and I still cannot think of a logical formula.

Any help is MASSIVELY appreciated.

[azumi]

As it shown your table in on ranges A1 to C4

1. put this on A6 and copied down and cross to Column B
=INDEX(A$1:A$4,INT((ROW(A1)-1)/4)+1)

2. Put this on C6 and copied down as necessary
=INDEX($C$1:$C$4,MOD(ROWS(A1:$A$1)-1,ROWS($C$1:$C$4))+1)

and try look on my file

[Trotters]

Hi Azumi,

Many thanks! That works in a limited way.

It's working out every permutation from column C but is fixing A and B
So it's always A1 and B1, A2 and B2, A3 and B3.

I need to be able to work out EVERY conceivable combination.

Example:
A1 B1 C1
A4 B2 C3
A2 B3 C2

[samba_ravi]

Please attach a sample excel file with expected result

[Trotters]

No need. I found a solution (link below). Works perfectly.

Thank you for your help anyway.

http://www.ashishmathur.com/create-a...out-using-vba/