Data Validation List

[Guest]

I have 3 worksheets in a workbook. I have a data
validation list in the 1st worksheet, the first cell in
the validation is blank. The list works fine. However,
when I go to the second worksheet I'm trying to come up
with a formula that says if there is nothing (empty cell)
in the 1st worksheet cell then return nothing in the
second worksheet cell; and if there is something in the
first worksheet cell, return the result. I'm stuck, keep
getting #VALUE! in the second worksheet, any suggestions.

This is my forumula:
=IF(C5="","",C5)&", "&IF(L5="","",L5)&", "&IF
(U5="","",U5)..and so on. Thank you.

 

[Andy B]

Hi

Try just putting the 1st cell's address in the 2nd cell. Basically, you want
the second cell to be the same as the first. In your 2nd cell type = and
then click on your first cell.

 

[Jason Morin]

You need to reference the other worksheet in your formula.
If the worksheet with the validation is named "Sheet1",
then you use:

=IF(Sheet1!C5="","",Sheet1!C5)&...

I recommend always clicking the cells you are referencing
in a formula so as to avoid errors like the one you're
encountering.

HTH
Jason
Atlanta, GA

 

[Guest]

Jason,

Thank you for your suggestion, I tried it but am still
getting the same result.