=IF($A$13="","",VLOOKUP($A$13,Tables!$B$1:$G$114,3,FALSE))
The sheet "Tables" has 10 tables with the very exciting titles "1", "2", "3", etc. I wish to enter the table number in cell "A13" on my main sheet and have it populate the table there. My research has led me to believe going down rows in "VLOOKUP" means switching to "INDEX" or "MATCH", however because there's no specific value I'm wholeheartedly looking for I'm struggling somewhat. I'd like to populate a number of cells with the formula, some 2 across and 1 down, some 3 across and 2 down and so on, all deriving from different tables on sheet "Tables"
Hope I've explained things about right! Thanks for the help!
The sheet "Tables" has 10 tables with the very exciting titles "1", "2", "3", etc. I wish to enter the table number in cell "A13" on my main sheet and have it populate the table there. My research has led me to believe going down rows in "VLOOKUP" means switching to "INDEX" or "MATCH", however because there's no specific value I'm wholeheartedly looking for I'm struggling somewhat. I'd like to populate a number of cells with the formula, some 2 across and 1 down, some 3 across and 2 down and so on, all deriving from different tables on sheet "Tables"
Hope I've explained things about right! Thanks for the help!