Keeping the source format when extracting data from multiple cells using Vlookup function

[praboos2001]

Hi all,

I am new member and topics discussed here are looking very interesting and very useful for me personally for a project that i am currently working on. I have used vlookup function to extract from a column based on a multiple drop down list. To extend the detail, i have 3 multiple drop down list in the output sheet and when all three of them are chosen, a particular cell has to extract data from a column in the input sheet. Using vlookup function it does work. However, i have superscripts in the actual input data column and when the cell extracts data it leaves out the superscript which makes the data look very odd as the numbers i have used in the superscript are references and i would like to have the data as i feed in.

Please suggest a solution. You help will be much appreciated.



Thanks

Prabu