office 365 VLOOKUP to return not only the cell data, but also the Cell Comment

[Cr4ig]

Is it possible for a VLOOKUP to return not only the cell data, but also the Cell Comment as well in Office 365, i have spent all day, looking through older threads and searching on line, after going from Excel were everything worked to now not, isn't good, i previosly used this in Excel but this no longer runs properley only parts of comments comes through if any at all.

=vlookupcomment($A4,DailyMarks!A:H,7,FALSE) this used to bring back what was in that cell and the comment has well, any help would be grateful thank you.

 

[Fluff]

There is not (and never has been) a function called "vlookupcomment" in Excel. It is probably a UDF, in which case you need to find out why that no longer works.

 

[Joe4]

No, VLOOKUP can only return the cell value, not the comments.
You would probably need VBA to return the comments.

If you used to have something called "VLOOKUPCOMMENT" that returned both, it would have to have been either a User Defined Function (created in VBA), or part of some sort of add-in, as there has never been a native Excel function by that name.