I would like to use the above function to return a value however the cell
used in the logical part of the formula contains text.

Is there away around this cell not having a value or is there another
formula that will return a value from an adjacent cell based on text?

I am using Excel 2003.

Thanks