Thanks, that brings me a lot closer! I don't understand what you meant well
enough, sorry. I will try to explain better.
I need to match the text in column 1 that a formula returns with the actual
formulas in column 2.
column 1 column 2
='M-Z Supplier List'!$B$11 = Mann!B11
When I look at column 1 the cells read mann and the formula is
='M-Z Supplier List'!B11
When I look at column 2 the cell reads 500.00 and the formula is
= Mann'!B11
I am thinking something like MATCH(TEXT(A10,"$#,##0.00"),(LEFT(B10,3)))
???
Thanks again,
Todd
"Peo Sjoblom" wrote:
='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
|