Thanks, but when I do the first one it comes back False. Any ideas why?

"Ardus Petus" wrote:

=IF(SheetA!A1="",SheetA!B1,SheetA!A1)
or:
=IF(SheetA!A1="","not provided";SheetA!A1)

HTH
--
AP

"nevergiveup" a écrit dans le
message de news: ...
I have multiple sheets in a workbook.

One sheet (call it Sheet A) has data that may or may not be inputted in
specific areas.
Another sheet (call it Sheet B) takes this data and populates cells that
are
in Sheet B.

I want some of the data from Sheet A, only if it is has been added, to
populate Sheet B and if it is not populated, I want it to refer to another
cell on Sheet A or to say "not provided".

Is this possible? (or make any sense!)