Dealing with Text in a Function cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 spreadsheets in one workbook that contain some of the same data.
I've used the following function to poplutate the data entered into one
spreadsheet into the other with the same data:
=IF('Reg Doc Tracking'!H2,'Reg Doc Tracking'!H2,"")

It works fine with any dates that are entered but I run into a problem when
I have text in the Reg Doc Tracking H2 cell. I need to be able to enter a
date or text into the field and have it populate into the other spreadsheet
that contains the same data.

I'm working with Excel 2003.

Thank,
Karen
 
Hi!

Try this:

=IF('Reg Doc Tracking'!H2<>"",'Reg Doc Tracking'!H2,"")

Biff
 
Hi!

Try this:

=IF('Reg Doc Tracking'!H2<>"",'Reg Doc Tracking'!H2,"")

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIf with And 0
Conditional formatting with multiple formula 2
SumProduct not Working in a Macro 6
Copying data entered in the last cell of a row on the same spreads 2
Multiple functions, conditional functions 7
Automate calculation... 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Last Modified By in a cell by user 3

Back
Top