Hi guys,

I have a sheet here:

https://docs.google.com/spreadsheets...it?usp=sharing

Can someone help me write an array formula on my tab: predicted scores whatsapp, where I am able to pull scores from cells B7 and C7 and input these into U7 and W7 onwards, whilst matching the name above these cells and the names on A7?

thank you!

R.