lookup cell reference and copy contents and comment from a range
 

I am trying to perform the following lookup function. From cell E1, lookup
an account (value) entered in cell A1 from a range of cells AA1: AA100. The
cells in the range inlclude account reference and a related comment in each
cell. From the lookup I want to copy both the cell content and comment into
cell E1. I'm not sure how to pull the comment into cell E1 along with the
account reference. Can I perform this using vlookup, a different formula or
do I need to create a macro?

Thanks