Trying to write a formula that will recognise a word value in one field then if one or more word values are meet in the second field then it returns a value in a third field. This needs to be able to meet several values in both the first and second f...
Thank you Jonathan,
I used a formula for what I needed and it is working for me at the moment. My fields are in the middle of the table so a little more difficult to work with.
Appreciate your time and suggestion will keep this in mine for few other ...
Thank you for the information on the formula, it works well with what I was trying to accomplish.
Regards,
Brian Masters
Managing director
Muddle’s Place
P: 03 6705 7070
M: 0447359 335
E: brian@muddlesplace.com
There are 5 option in both 1 and 2 fields giving 25 possible outcomes, however some of the outcomes are the same for each combination option of field 1 and 2.
I will give it a go and see if it works. I have tried to us a nested IF statement however i...
