Formula help!

Question

need help writing a formula that returns the comment from a different sheet relating to a specific line

Answer 1

If you want to get only one information (cell) from the other sheet you can use
B2: =VLOOKUP(A2,Sheet2!A:B,2,0)

https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

If the information is in a different column, e.g. column K, use MATCH/INDEX
B2: =INDEX(Sheet2!K:K,MATCH(A2,Sheet2!A:A,0))

If you want to get more information's from the other sheet, I suggest to use MATCH in a helper column and use the cell reference within INDEX, because the term has to be searched only once.
B2: =MATCH(A2,Sheet2!A:A,0)
C2: =INDEX(Sheet2!B:B,$B2)
drag C2 to the right till the end of your data.

https://support.office.com/en-us/article/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a
https://support.office.com/en-us/article/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd

If you need further help please share your (sample) file.

Andreas.

Answer 2

Hi Andreas

Incase I have not explained correctly its not comments as in ones you insert in a cell I just mean text I have written in a cell. Does that make a difference?

Answer 3

You said comment, means this:

https://support.microsoft.com/en-us/office/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8

Believe me or not, there is no way to access comments with a formula.

Andreas.

Answer 4

Thanks Andreas but there must be a formula that you can use to look up the comment on a specific line and return it on a different sheet?

Answer 5

You can not access comments with a formula, you can access cells only.

Andreas.