I am attempting to populate values from the "LMPA" tab to the "stats" tab as per the attached spreadsheet. For instance, stat 3 for outpatient revenue (highlighted in blue) for dept. 5100 (highlighted in green) is .91 (cell D4) as per the "LMPA" tab. I would like to populate the .91 stat 3 value (cell C3 ) in the "stats" tab I attempted to use the Sum Product formula but it doesn't work. I believe I know why but I am not sure what formula to use.
Thank you for your help.
Gina
Thank you for your help.
Gina