Excel INDIRECT=eval(), vlookup

Was looking around for a way to dynamically evaluate cell references and finally after some digging found INDIRECT, which was just what I was looking for. VLOOKUP looks handy to transfer over data without having to specify a cell range.