Forum Discussion
Help with formula in Exc
I have a spreadsheet with multiple tabs at the bottom. On the Master I have one column with drop down list. I want the info on the master tab to feed over to the tab corresponding to the tab that m...
That didn't do anything - it just put the formula in A2 of the lead sheet but didn't return any data?
As long as you put it right it should work by now..
Put the sheet name on cell N1, then
the formula must have a bracket {=formula} at the beginning and at the end, like this:
{=IFERROR(INDEX(Master!$A$2:$H$100,SMALL(IF(Master!$B$2:$B$100=$N$1,ROW(Master!$B$2:$B$100)-ROW(Master!$B$2)+1),ROW()-ROW($A$2)+1),MATCH(A$1,Master!$A$1:$H$1,0)),"")}
then drag the formula across the table
Master Sheet:
Lead Sheet:
Install Sheet: