='M-Z Supplier List'!B11&" "&TEXT(Mann'!B11,"$#,##0.00")

or if you meant that one formula retruns a string that you want to use as a
reference in another formula

=INDIRECT("'"&'M-Z Supplier List'!B11&"'!B11")

--

Regards,

Peo Sjoblom

"Todd" wrote in message
...
I need to match the returned value in one formula with the text in
another
formula. How can I do this?

Formula 1: ='M-Z Supplier List'!B11 and returns" Mann"

Formula 2 : = Mann'!B11 and returns a dollar value


TIA