Hi all,
I am after a formula that compares figures in cells to each other and if they match will give me a TRUE response or FALSE if they don't.
For example; Cell A54 must match with A54 on worksheet 2, but as must 4 other cells, say B54, C54, D54, E54 match to the corresponding cells on worksheet 2 to fulfill the query. Also what is the maximum conditions that can be tested as I may need more than 4 tests.
If anyone can be of assistance it would be very appreciated!
I am after a formula that compares figures in cells to each other and if they match will give me a TRUE response or FALSE if they don't.
For example; Cell A54 must match with A54 on worksheet 2, but as must 4 other cells, say B54, C54, D54, E54 match to the corresponding cells on worksheet 2 to fulfill the query. Also what is the maximum conditions that can be tested as I may need more than 4 tests.
If anyone can be of assistance it would be very appreciated!