Easy text formulae

  • Thread starter Thread starter jason.jaesung
  • Start date Start date
J

jason.jaesung

Hi All,

I'm sure most would be familiar what to expect from my simple text
formula below...

="We sold "&B21&" item(s) for $"&D21&" to customer type "&G21

This would work only if cells B21, D21 and G21 were on the same
worksheet.
I'm a bit stumped on how to refer to cells on another worksheet.

Any clues?

Thanks
 
="We sold "&Sheet2!B21&" item(s) for $"&Sheet2!D21&" to customer type
"&Sheet2!G21


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
In this example B21 is on another sheet

="We sold "&'Sheet 2'!B21&" item(s) for $"&D21&" to customer type "&G21

Mike
 
Back
Top