novabond
New Member
- Joined
- Mar 26, 2022
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
hello.
Im really stuck, I hope someone can help.
The formular I am looking for has this criteria:
note, (as i want to try, and best explain the criteria still)
so it will also be that,
If there is a "P" in Include cell
and
If there is text in one or both cells is set A, and both or one of these text doesnt match part text in Lookup cell
AND
If there is text in one or both cells is set B, and both or one of these text does match part text in Lookup cell
or visa versa
I need this to return "" (blank) in the Output cell
and
I was also struggling with a simple way to get the formular, not to recognise an empty cell in sets A or B, as being matched as TRUE, with part text in the Lookup cell
btw, I use "P" in cells, whereby I was to display a tick, by also having font Wingdings 2......
and
as per the illustration image below, I will be copying this formular to other cells.
but, I can eaisly rename the cells in the formular myself, if you want to write this formular uisng the first cells in a worksheet say:
(NB: I wanted to include my actual cell references earlier, incase it becuase relevent in the overall solution, I also cant get XL2BB to work for me at the moment, so cant drop in minisheets to help)
A$1:A$2, set A
A$3:A$4, set B
A5, Output cell
$J5, Include call
$K5, Lookup cell
thanks so much for reading this!... fingeres crossed someone wants to take it on... tnanks again !
Im really stuck, I hope someone can help.
The formular I am looking for has this criteria:
- formular in cell S28 (i will refer to this cell as Output cell)
- If there is a "P" in cell $BA28 (I will refer to this cell as Include cell)
- value if true :
- If there is text in either S$11 OR S$15 (I will refer to this range as set A) and it matches part of text in $BN28 (i will refer to this cell as Lookup cell)
- AND
- If there is text in either S$19 OR S$23 (i will refer to this range as set B) and it matches part of text in $BN28 (as above)
- = "P"
- value if false :
- = "" (blank)
- value if true :
- If there is a "P" in cell $BA28 (I will refer to this cell as Include cell)
note, (as i want to try, and best explain the criteria still)
so it will also be that,
If there is a "P" in Include cell
and
If there is text in one or both cells is set A, and both or one of these text doesnt match part text in Lookup cell
AND
If there is text in one or both cells is set B, and both or one of these text does match part text in Lookup cell
or visa versa
I need this to return "" (blank) in the Output cell
and
I was also struggling with a simple way to get the formular, not to recognise an empty cell in sets A or B, as being matched as TRUE, with part text in the Lookup cell
btw, I use "P" in cells, whereby I was to display a tick, by also having font Wingdings 2......
and
as per the illustration image below, I will be copying this formular to other cells.
but, I can eaisly rename the cells in the formular myself, if you want to write this formular uisng the first cells in a worksheet say:
(NB: I wanted to include my actual cell references earlier, incase it becuase relevent in the overall solution, I also cant get XL2BB to work for me at the moment, so cant drop in minisheets to help)
A$1:A$2, set A
A$3:A$4, set B
A5, Output cell
$J5, Include call
$K5, Lookup cell
thanks so much for reading this!... fingeres crossed someone wants to take it on... tnanks again !