I have a problem that I don't know if its possible or not. so im a big Gamer and trying to see if i can build a spreadsheet to see the best things to equip.
so my values that i want to populate my spread sheet is from: 10 different lists each list contains
10 rows
5 columns
so based upon 3 criteria(level 1-10, where to put item on body, type of item) that is selected to tell which list to use, row and column.
then retrieve info(not all cells contain data) and populate the spreadsheet for said criteria.
The problem I have using If/And formulas is there are too many in-bedded. Also not sure how to keep using same cells in spread sheet
for the different queries i do.
so my values that i want to populate my spread sheet is from: 10 different lists each list contains
10 rows
5 columns
so based upon 3 criteria(level 1-10, where to put item on body, type of item) that is selected to tell which list to use, row and column.
then retrieve info(not all cells contain data) and populate the spreadsheet for said criteria.
The problem I have using If/And formulas is there are too many in-bedded. Also not sure how to keep using same cells in spread sheet
for the different queries i do.