Creating a loot table, cannot find the proper formula

Howdy howdy. I'm attempting to create a simple loot table that combines the text of a portion of the A row that will be the row containing suffixes, and the B row that will contain weapon / item names.
I'm trying to get to the point where it will select a random suffix and weapon / item and combine them.

I'm still VERY VERY new to excel but I touched on it a year or two ago. I'm not quite smart so it may be to.. communicate idea's to me.

As an example, this is my simple set up :
Capture.PNG

So what exactly can I do for this to start producing combinations? I know it's not exactly the simplest thing to be attempting as I've just gotten back into excel a couple hours ago, but it's something I'd like for recreational use with friends.

EDIT : Apologies for any bad grammar, and the likes. Also Concatenate seemed interesting to my needs but it seemed to not be EXACTLY what I needed.

Welcome to the forum.

You seem to have a lot of empty space on your sheet and a lot of merged cells, which cause problems with formulae, so unless you're really attached to it, I suggest starting from scratch with a new sheet.

Put your title in row A (A2 will probably work best) and make the font bigger - the row will automatically increase in size.
In A2 and B2 type 'Prefix' and 'Weapon'.
List your prefixes from A3 downwards.
List your weapons from B3 downwards.
Leave column C blank to give a gap.
In D2, type 'Random Weapon'.
In D3, use this formula:

Formula:

Please Login or Register  to view this content.

The parts of the formula are:
COUNTA(range) - counts the number of non-blank cells in the range;
COUNTA(range)+2 - because the range starts in row 3, this gives the row number of the last used cell in the range;
RANDBETWEEN(lower number, upper number) - gives a number between 3 and the last-used row;
INDIRECT("A"&number) - this converts to a cell reference, so Excel 'sees' A5 or A7 or A17, etc;
& is a concatenation which joins results together;
" " gives a space.
Putting it all together in plain language:
=Result from cell ( A number between 3 and last row of column A) space result from cell ( B number between 3 and last row of column B)
For example: A11 space B8
Which will give you whatever is in A1 ('Crystal' for example) and B8 ('Dagger' for example).

The attached file should show you what I mean by all of the above. Hope that all helps and enjoy playing!

I got your PM - good luck with trying it out. If you run into any problems, please get back to us - use this thread if it's a continuation of the same problem.

Once you're happy that your question has been answered, please mark the thread as Solved so others know there's an answer here (see instructions in my sig). Thanks.