Automatically expanding cells to accomodate VLOOKUP results

Excel 2010
I am using VLOOKUP to bring sentences into cells in the left-most column of Sheet 1, based on what product name is entered by a user. These sentences are on sheet 2 in an array, and range in length from a few words to a few sentences per cell. I use Wrap Text to make sure the sentences don't stretch out across the page on Sheet 1, and I have used "Auto-fit Row Height" to make sure the cell accomodates the sentence correctly. However, when I change the product name, VLOOKUP brings in a new set of sentences (they vary according to the product entered), and the cell heights don't change to accomodate the new sentences. Can anyone tell me if it is possible to get the cells to dynamically change to suit the sentences each time a new product is entered by the user? Please feel free to ask me any questions.

Hi DILIPandey,
Thanks for your reply. If I enter the data manually, the autofit works, but using the formula it doesn't. F2 has no effect unfortunately. Is there any way around this?

So, should I ask the same question in a VBA sub-forum then? I need the cells to adjust to the size of the incoming data.

Can you upload an example of what you need doing?

Thanks Eoghan.
Here's a stripped out sample of what I'm trying to achieve. The user would enter a product name (as listed in column A, Sheet 2) into the yellow box on Sheet 1. This will bring up the relevant information. Since this is to be printed (and will be surrounded by lots of other data), I need the cells receiving the data (Sheet 1 A3 - A23) to dynamically change height to fit the data to be displayed. I've used Wrap Text as I do not want the data scrawling all across the page.

Hi r011in,

Sorry for not getting back to you sooner. I've tried to open your file but unfortuantely can't. I think its because I'm trying to do this at work! Hopefully somebody else will be able to help you...