Retrieve information from multiple lines for the same ID/code number

[Surreybloke]

Hello,

I have a change report from Salesforce that uses opportunity numbers and shows whether a change has been made to it. Sometimes, there can be more than one line for a single opportunity where more than one "thing" has been amended.

I was wondering whether it's possible to retrieve this information on a different report or not. A LOOKUP would only retrieve one item but it would be really good if there were a way of retrieving information from multiple rows for the same opportunity number without having to manually go into it.

 

[dreid1011]

XLOOOKUP or FILTER should be able to do just that.

 

[dreid1011]

XLOOOKUP or FILTER should be able to do just that.

Minor correction. Filter can do that for you.

 

[Surreybloke]

Minor correction. Filter can do that for you.

Thank you, I'll give that a try. It's not a formula I've used before, or recall using.