Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Keep the worksheets grouped. Now you want to display the cell address containing the quarterly donation displayed in cell L 2 . In cell L
Keep the worksheets grouped. Now you want to display the cell address containing the quarterly donation displayed in cell LIn cell L insert the ADDRESS function with nested XMATCH functions. The first nested function looks up the Donor ID in cell K and compares it to the range A:A The second nested function looks up the quarter entered in cell K and compares it to the range A:GDisplay the resulting address as a relative reference.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started