There is a sheet named MASTER where the data of all items are available with a code for each item. The text description has few words bold and italics.
There is another sheet named LIST where I am trying to prepare a list of selected items based on the assigned code.
For matching the description in the LIST sheet, I have used the following formula
=IFERROR(INDEX(MASTER!$C$2:$C$5,MATCH(B2,MASTER!$B$2:$B$5,0)),"")
But, the formatting of text as in the MASTER sheet is not preserved in the LIST sheet. The text description in LIST sheet appears as plain text.
Could anyone help?
my worksheet is uploaded http://s000.tinyupload.com/?file_id=...26694586699742
Bookmarks