Forum Discussion
marietuttle1973
Dec 17, 2024Brass Contributor
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...
marietuttle1973
Dec 19, 2024Brass Contributor
That didn't do anything - it just put the formula in A2 of the lead sheet but didn't return any data?
Rodrigo_
Dec 19, 2024Iron Contributor
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: