Talk:Damage Calculator/@comment-11753608-20130825054805/@comment-15871805-20130825135804

By using INDIRECT and MATCH with VLOOKUP you can make every equation in the column look the exact same and still get the correct results for each enemy. The equation is much longer and looks more complex though.

In an example of the Grineer Flameblade, INDIRECT("A"&ROW,TRUE) replaces the name references (A33 in this example). And MATCH("StatName",EnemiesTable,0) replaces all of the row_index_num of VLOOKUPs.

This example assumes that you have your enemies table setup with Health, Shields, Armor, etc. along the top row and the names of the enemies in the first column.

You can even do it with the base damage column, but it requires a few modifications to your table layout.