Ability to reference cell while looking up a value

I am completely stumped on how I can go about my situation... My spreadsheet requires a way that I can lookup the value in a cell, which is a formula containing text and math, however that cell is a...