Forum Discussion
Return a value from a reference based on multiple kolumns
Is there anyone that could help me identify the formula/s for retrieving a value from a table with multiple kolumns. The two columns which shall get the data are YTD target and Monthy target . T...
In F3:
=SUM(INDEX($B3:$E3;ROW(INDIRECT("1:"&MATCH($A$1;$B$2:$E$2;0)))))
If you are not on Microsoft 365 or Office 2021, confirm the above formula with Ctrl+Shift+Enter.
In G3:
=INDEX($B3:$E3;MATCH($A$1;$B$2:$E$2;0))
Fill down.
Thank you so much, I will try the formula right away. This forum is really fantastic! I never thought I'd get a reply so quick.
I'll get back to on the progress.
Once again, big thank you!
/Barbara