Checking two cells for text, returning one value

**sdaddy** · 06-09-2009, 02:12 AM

Hi All,

I have cells E21 and E22 in 01 (tab/worksheet name) which users will fill in accordingly. Only one cell will be filled in at any one time, e.g. Either E21 or E22 will have text but am unsure as to which one users will use etc.

In my summary sheet i have a field in cell H7. In this field i need to extract the data from either E21 or E22 and populate this field with what was typed in E21 or E22.

Im guessing i need to use an IF or OR statement but cant seem to get it to work.

e.g. if(istext('01'!E21),....

Any help much appreciated.

**Excel Matic** · 06-09-2009, 02:27 AM

Use this in cell H7 of summary sheet:

Please Login or Register  to view this content.

**sdaddy** · 06-09-2009, 02:31 AM

Thanks for your help mate. Much appreciated.

- Sdaddy

**DonkeyOte** · 06-09-2009, 02:49 AM

If as you say only one is ever populated and assuming entries are not numbers (not clear) you could avoid IF using REPT:

=REPT('01'!E21&'01'!E22,1)

To handle possibility of both being populated

=TRIM(REPT('01'!E21&" "&'01'!E22,1))