Populate Cell IF A Cell From Another Page in the Same Worksheet Contains Anything

[tcvicon]

I did try searching for this and was unable to find a solution, and I'm sure it's been answered 100 times. I apologize in advance.

Basically what I have is a worksheet with a number of tabs. For arguments sake, let's call them Tab 1, and Tab 2.

On Tab 2, I'd like to reference a cell on Tab 1, and populate a cell on Tab 2 IF and ONLY IF the cell I'm referencing on Tab 1 contains data of any kind (numbers, letters, etc.)

In layman's code (from a cell on Tab 2):

=IF Cell A1 on Tab 1 contains any data -> display the contents of 'Tab 1'!A1 ELSE leave cell empty


Thank you in advance for the help!

[Pete_UK]

You would do it something like this:

=IF('Tab 1'!A1="","",'Tab 1'!A1)

The apostrophes are needed if your sheet names contain spaces.

Hope this helps.

Pete

[tcvicon]

Pete, that worked perfectly, Thank you!

Just so I understand the logic, in that formula we're stating "if Tab1!A1 contains nothing, display nothing, otherwise display the contents of Tab1!A1, correct?

Again, thank you for the fast response!

[Pete_UK]

Yes, you got it. It could also be written like this:

=IF('Tab 1'!A1<>"",'Tab 1'!A1,"")

(If it is not empty then return the value otherwise display nothing - just the opposite logic).

Hope this helps.

Pete