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