Generation of random numbers from a Lognormal distribution

[Romoluzzi]

Hi everybody,
I have to simulate losses occurring in a portfolio of non-life policies and I need to generate a several thousands of random numbers but from a Lognormal distribution. and repeat the operation many thousands of times. I tried the Excel add-in instrument "data Analysis" but it proposes only normal, poisson and binomial distribution as sources of random numbers.
Can you suggest any other way of extracting numbers from a Lognormal distribution?
I thank you in advance for your usual valuable assistance.
Marco.

[Jakobshavn]

Is this what you need??:

=exp(normsinv(Rand()))

[Romoluzzi]

Thanks Jacobshavn, but unfortunately this is not what I need.
In fact I have to try several lognormal distributions with different means and std deviations......
Any other suggestion?

[Jakobshavn]

I will investigate.

EDIT:

Please examine the attached workbook to see if it of any value.

[Romoluzzi]

Many thanks again, Jacobshavn,
I will try it and see what it comes out, it seems promitting....

[Jakobshavn]

I did a very simple plot and it looks "reasonable"