Talk:Damage Calculator/@comment-11753608-20130825054805/@comment-11753608-20130825121751

This is the only thing I have found so far:

The INDIRECT function references cells without using quotation marks. This function evaluates the result of the cell reference. For example, if cell A1 contains the text "B1," and B1 contains the word "TEST," the formula =INDIRECT(A1) returns the result "TEST."

However, referencing a cell with quotation marks returns the result of the cell contents. In the example in the previous sentence, the formula returns the text string "B1" instead of the contents of cell B1.

So, perhaps it would work if you did not have "" in the C1 cell? But I don't see how that means we could have only 1 equation. The issue is the HP, Shields, and armor equation has to use values specific to each mob. So, I don't know how something you are thinking about would do VLOOKUP's.