Single cell that looks at two cells and displays text either one when entered

[timheffo]

I have two drop down lists and I am wanting a cell on another sheet to look at both of these drop down lists and when a selection is made in one of the lists it is displayed in the cell on the other sheet.

Was using =Sheet1!A1 when I only had one drop down list now I have two drop down lists not real sure on how to do this.

 

[Jonmo1]

Welcome to the board...

What if BOTH cells have a value, which one do you want?

 

[timheffo]

Either is fine as it states on the spreadsheet to use list 1 or list 2 not both together.

Thanks.

 

[Jonmo1]

I guess I should make the question clearer...

Is it POSSIBLE for both cells to be populated?

IF Yes, which one should be returned in such a case.
Saying Either doesn't make much sense.
Excel isn't great at making choices for you,
It is better if you make an absolute choice.

While we're at it, what if both cells are blank?

 

[Jonmo1]

This will...

If BOTH Cells are blank, return blank
If BOTH Cells have a value, it returns A1
Otherwise, returns whichever is populated.

=IF(A1="",IF(B1="","",B1),A1)

 

[timheffo]

Perfect! Thank you very much!

 

[Peter_SSs]

Perhaps if they happen to both be populated, you could return them both?
=A1&IF(COUNTA(A1:B1)=2,"|","")&B1

 

[timheffo]

If you wanted to make the last cell that was used the one that displays data could this be done as well.

So you could select list A1 it displays it, if you then select list B1 it displays it, then if you select A1 again it displays that cell?


This formula below provided
=IF(A1="",IF(B1="","",B1),A1) works fine for what I need, this is more for personal interest if you can how would you?

 

[Aladin Akyurek]

If you wanted to make the last cell that was used the one that displays data could this be done as well.

So you could select list A1 it displays it, if you then select list B1 it displays it, then if you select A1 again it displays that cell?


This formula below provided
=IF(A1="",IF(B1="","",B1),A1) works fine for what I need, this is more for personal interest if you can how would you?

The idea of last text value would work indeed, in particular with a larger range...

=LOOKUP(REPT("z",255),A1:B1)

=LOOKUP(9.99999999999999E+307,SEARCH("?",A1:B1),A1:B1)

The latter avoids formula blanks (i.e., "") as last text value.