Populating a Number Value based upon a CONTAINS condition

Jessb9187

I am collecting feedback from a series of clients. I am separating each client by their revenue number to show the satisfaction rating for each "tier" of our client base.

As such, I am trying to find a formula which will populate their revenue number value associated with their specific client number.

For example, client #1234 has a revenue number value of 5,678,900 associated to its row. I need my sheet (which auto populates as each feedback form is filled out) to display that 5,678,900 number automatically based upon the client # as it populates into a new sheet. The sheet from which these number populates is not managed well and so the client number value could contain a series of numbers which means that client has more than 1 location for their logo.

I've tried some variations of Value and Contains but I'm failing to find the right formula.

Paul Newcome

Try something along the lines of...

=SUMIFS({Other Sheet Revenue Column}, {Other Sheet Club Number Column}, FIND("1234", @cell) > 0)

Paul Newcome

Can you provide a screenshot that shows an example of your source data? Sensitive/confidential data can be removed, blocked, and/or replaced with "dummy data" as needed.

Jessb9187

Capture2.JPG

Definitely. I need the MRGP amount to populate in my sheet if this sheet contains the same numbers in the club# column as what's found in my sheet.

Paul Newcome

Can you also expand on this part?

"The sheet from which these number populates is not managed well and so the client number value could contain a series of numbers which means that client has more than 1 location for their logo."

Jessb9187

Capture3.JPG

Here's another screenshot of that sheet. So that club # could have a few numbers in there instead of just 1 number. If I can filter through that to say, "show me the revenue number for a cell that contains these specific numbers", that's what I'm trying to do. I hope that makes sense.

Paul Newcome

Try something along the lines of...

=SUMIFS({Other Sheet Revenue Column}, {Other Sheet Club Number Column}, FIND("1234", @cell) > 0)

Jessb9187

That works! Thank you so much.

Paul Newcome

Happy to help! 👍️