indiemusicboy
New Member
- Joined
- Apr 9, 2020
- Messages
- 47
- Office Version
- 365
- Platform
- MacOS
Looking for a search, match, return value forumla.
I have a worksheet that has CSAT survey data in it; company name (Column D) and rating (Column F). See below. The rating system is Awesome, Average, and Poor.
Survey Data Worksheet format:
I have hundreds of individual worksheets in the same workbook for each specific customer containing other unrelated data points about them.
On the individual customer worksheet I need to have a specific cell [example: 'Acme Company'!R10] show the average rating [example: 'Survey Data'!F:F] from the survey worksheet if the customer name matches. The survey worksheet may have the customer name once, several times, or not at all.
"Customer" Worksheet format:
Any ideas where to start here?
I have a worksheet that has CSAT survey data in it; company name (Column D) and rating (Column F). See below. The rating system is Awesome, Average, and Poor.
Survey Data Worksheet format:
I have hundreds of individual worksheets in the same workbook for each specific customer containing other unrelated data points about them.
On the individual customer worksheet I need to have a specific cell [example: 'Acme Company'!R10] show the average rating [example: 'Survey Data'!F:F] from the survey worksheet if the customer name matches. The survey worksheet may have the customer name once, several times, or not at all.
"Customer" Worksheet format:
Any ideas where to start here?