Populating a Number Value based upon a CONTAINS condition
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.
Best Answer

Try something along the lines of...
=SUMIFS({Other Sheet Revenue Column}, {Other Sheet Club Number Column}, FIND("1234", @cell) > 0)
Answers

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.

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.

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."

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.

Try something along the lines of...
=SUMIFS({Other Sheet Revenue Column}, {Other Sheet Club Number Column}, FIND("1234", @cell) > 0)

That works! Thank you so much.

Help Article Resources
Categories
Check out the Formula Handbook template!