Forum Discussion
Is it possible to get the combinations using some lookup or any other functions
One Master table should look in 3 other tables. When selected thru a drop down it shud bring down the below outputs: Scen: AC //Should be dropdown Month: Jan //Should be dropdown Org: O...
If you are on Office365 subscription you may use TEXTJOIN. For the first of highlighted cells
the array (Ctrl+Shift+Enter) formula could be
=TEXTJOIN(":",TRUE,OFFSET($B$4,MATCH(B15,$A$5:$A$7,0),0,,MATCH(C15,$B$4:$F$4,0))&"$"&INDEX($C$10:$C$12,MATCH(D15,$B$10:$B$12,0)))
Please see attached.