hi pecoflyer,

Thank you very much for responding to my query. Please find attached the sample sheet. As can be seen in the attached sheet, i have created two sheets namely, data input and data output sheets. In the output sheet, in cells A2 and A4 i have created a drop down list out of which A4 is a dependent list on A2.

I have used vlookup on cells B9,10 &11 that extracts data from data input sheet based on what is selected in cells A2 and A4 in the drop down list.

The data in input sheet on cells E2 to E10 has got numbers as superscript and the same data in the output sheet on cell B11 doesn't have the numbers as superscript.

Though this looks very simple, its very important for me as i have to present this to a client and this doesn't look professional.

Looking forward to hear from you.

Thanks in advance

Attached Files

Test sheet - vlookup from dependent drop list and keep source formatting.xlsm (60.4 KB, 35 views)