I have a simple workbook with many sheets, on the first sheet i have a dice roller which gives me a 2 D6 (2-12) and a D66 (11-16,21-26 etc) value And i want to output my lookups to this sheet also.
The D66 outputs to G12 and provides a Title from the second sheet titled D66
=VLOOKUP(G12,'D66'!A1:B36,2)
Now this title will be broken down by the 2D6 to a specific category each has its own sheet
=IF(AND(G12=11),VLOOKUP(G11,'basic electronics'!A1:B12,2),0)
now so far this works, but only if i get an 11 on the D66.
How do i now incorporate the other 35 sheets?
ive been drawing blanks all week and any help is much appreciated.
Bookmarks