Data Validation List

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

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.
 
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.
 
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
 
Back
Top