Multiple IF-s, or VLOOKUP

[Dado87]

Hi all!

Im new to this forum, so please forgive me if i posted in wrong section.

I have a problem, and ive been trying to find solution, but barely with any success (i am using Office 365ProPlus version).

- with my limited skills, i am trying to have one main column, which cell will gather data on multiple other columns cells and ,depending if those columns are blank, or have anything in cell, display text.

So, for example:

* Cell A1 will give 3 possible texts (Send to department1, Send to department2, Send to department3)
* Send to department1 will be displayed if B1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if C1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if D1 cell has anything, wont be displayed if cell is blank

* Text priority should be determinated to the right, so if both B1 and C1 cells have anything, then Send to department2 should be displayed while Send to department1 should be ignored...etc with further cells

So far, i am able to display one text depending on one cell, but i am not able to do this with multiple cells.

This is my current formula:

=IF(B1<>"";"Send to department1";"")

Please note that i use ;
My formulas are not working with ,

If any help or advice is given, i would really appreciate it. Thanks!

[bebo021999]

May be:

Please Login or Register  to view this content.

[Dado87]

May be:

Please Login or Register  to view this content.

Thank you for your quick answer, however, it didnt work.
Check attachment please, i have made an excel example of what im using and what i need.

Cell A1 will contain Text, while C1 and F1 will have data or be blank. If they have data, text in A1will be displayed, if blank, then text in A1 wont be displayed.

Also, with priority of cells to the right.

[bebo021999]

Quite different issue.
Anyway, try:
=IF(SUMPRODUCT(LEN(C1:F1))=0,"","Department1")

[Dado87]

This also didnt work.

Text "Department1" didnt depend on data in cell C1, and there is no text "Department2" which depends on data in cell F1.

(when i removed data from those cells, A1 is not changed, it says "Department1" whatever i do).

I also dont want data between cells D and E to be used, just C1 and F1.

[joris moerings]

Hi,

We don't mind you being new to the forum however it's hard to help if the question changes.

Your initial question was:
* Cell A1 will give 3 possible texts (Send to department1, Send to department2, Send to department3)
* Send to department1 will be displayed if B1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if C1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if D1 cell has anything, wont be displayed if cell is blank
* Text priority should be determinated to the right, so if both B1 and C1 cells have anything, then Send to department2 should be displayed while Send to department1 should be ignored.

Just notice there's no criteria relating to filling Cell A1 with the text "Send to department3"

Going forward from that:
this formula states exactly what's asked for in the question.

Please Login or Register  to view this content.

This is an Array formula so should be entered by combining Ctrl+Shift+Enter.

[Dado87]

Hi,

We don't mind you being new to the forum however it's hard to help if the question changes.

Your initial question was:
* Cell A1 will give 3 possible texts (Send to department1, Send to department2, Send to department3)
* Send to department1 will be displayed if B1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if C1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if D1 cell has anything, wont be displayed if cell is blank
* Text priority should be determinated to the right, so if both B1 and C1 cells have anything, then Send to department2 should be displayed while Send to department1 should be ignored.

Just notice there's no criteria relating to filling Cell A1 with the text "Send to department3"

Going forward from that:
this formula states exactly what's asked for in the question.

Please Login or Register  to view this content.

This is an Array formula so should be entered by combining Ctrl+Shift+Enter.

Im sorry, maybe i didnt define the question very best.

Could you please try to edit Example excel file which i attached above?

- 3 cells are used for this, A1, C1, and F1
- if C1 and F1 dont have any value (date, number, letter) then A1 will be blank
- if C1 has any value, but F1 doesnt have, A1 will display text "Department1"
Attachment 690973
- if F1 has any value, but C1 doesnt have, A1 will display text "Department2"
Attachment 690974
- if both C1 and F1 have any value, A1 will display text "Department2" because i want that F1 has priority over C1
Attachment 690976

Cells between, like B1, D1, E1 will contain another data so i dont want them to be used in formula.

[bebo021999]

Try in A1:
=IF(F1<>"","Department2",IF(C1<>"","Department1",""))

[Dado87]

Try in A1:
=IF(F1<>"","Department2",IF(C1<>"","Department1",""))

Thank you, this works on my home pc!
Now i cant wait till monday to try it at work