I'm designing a spreadsheet-based, "choose your own adventure" adventure game.
The first step is to choose a character from a drop-down box (A14). The contents of the drop-down box are listed in column A of sheet 2, with various statistics such as weight, height and hair color listed in columns B:G in rows adjacent to the name they go with.
So here's my problem: how do I phrase a formula in sheet 1 so if the drop-down box hasany of the names from sheet 2(which it will), a cell in sheet 1 will display the statistic associated with that name? I made it work with a nested formula, but it took a long time to write, and I'll have to repeat it for every single cell with a similar goal in the spreadsheet. Which would be awfully labor intensive.
My formula is: If(A14=sheet2.$A$1; sheet2.$B$1; If(A14= sheet2.$A$2$;sheet2.$B$2; If...etc, repeated for every name and every statistic.
I'm trying to make something like this work: If(A14=sheet2.$A$1:$A$14; sheet2.$B$1:$B$14)
Bookmarks