Forum Discussion
Solved
How do I automatically fill columns based on a cell value from the same workbook.
When doing quotations I make use of standards (Std No.) where the different standards have their own BOMS (BOMS = Bill Of Materials) When I enter a standard number (Std No.) in cell F7 (in this case ...
- Riny, I realise my mistake. a Bit of language misinterpretation. I have simply copied the formula and paste it in cell G7 and not copying it down. Thank you for your help and the attached file.
IJanGreyling In G7, use this formula and copy it down:
=INDEX($T$8:$X$20,ROW()-ROW(G$7),MATCH(F$7,$T$5:$X$5,0))
In case you ae an MS365 subscriber it can become a bit easier. For instance:
=FILTER(T8:X20,T5:X5=F7)