View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lucy Lucy is offline
external usenet poster
 
Posts: 37
Default How to show original comment in cell when using Vlookup in Excel?

Hi there,

There are 2 worksheets on the same workbook.

Sheet#1 consists of raw data
Sheet#2 consists of a Vlookup for looking up data from Sheet#1

I've added comments on several cells in Sheet#1
After I use Vlookup function on Sheet#2, only the cell value shows but NOT
the comments. How can I show the comments as well?

Thanks.