Hello can anyone help, im trying to figure out a formula for this, lets say i have worksheet A and B, if the value in column A worksheet A equal to the value in column A worksheet B, then the result will be "TRUE" in column B worksheet B. BUT if the value is NOT EQUAL the result will be "FALSE" in red color. what formula should i put in column B worksheet B ?
If formula excel


What exactly do you mean?
WSA A1 = WSB A1
Or do you mean that WSA A1 appears somewhere in WSB column A?
The colour can't be done with a regular formula. You'll need conditional formatting (on the Home ribbon) for that.

sorry for the lack of information. let me illustrate:
. ........WS1................ . WS2
============ ============
.. A ......B ....C. . . .A ......B ........C
 
1 x ....100........ 8 ..z.... 700 ....FALSE
2 y .....200. . ....9 ..r..... 600
3 z ......300... . 10 .x.... 100 ....TRUEnb. 1238910 is a #cell
i wonder if its using vlookup formula?

Try:
=ISNUMBER(MATCH(A2,'WS1'!A:A,0))
copied down
To colour the FALSE, you need to conditional format for "cell value =" "=FALSE"
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!