# ROCORD A VARIANCE USING VLOOKUP OR CNDTL.FRMT

Closed
SAM - Feb 17, 2010 at 02:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 17, 2010 at 03:03 PM
Hello, Im using Excel 2007

Please help me determine wether i use VLOOKUP or Conditional Formating to find a difference and list that in my spreadsheet. Please see below.

Column A Column B Column C
1 2 V
1 1
1 3 V
2 1 V

If Column A is not equal to Column B mark a V in column C. - How do I do this?

## 3 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 02:20 PM
You mean if for same row, value of A and B are not same ? In that case use an IF statement like

=IF(a2=b2, "", "V")
I dont understand that doesn't seem to be working.

I do want what you expalined but I tried that formula in Column C and it does not hold the formula.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 02:43 PM
If there is a value in cell a2 and b2 and u put this formula in c2, it will work

put full line

=IF(a2=b2, "", "V")

if a2 is same as b2, then nothing will appear
if a2 is diff from b2 then V would show
Ok i got as far as

=IF(a2=b2,

it seems as if the formula bar doesn't pick up after that.

is it =IF(a2=b2,(space)"",(space)"V")

are there spaces after the comma's? - becasue this is not working...
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 03:03 PM
it is as you said. space is not important but " are

so after your comma, add two double quotes ", so it would look like ""
then a comma and then one double quote and then letter V followed by one more double quote and then )

why dont you copy and paste in the formula bar ? If you copy and paste in cell it may split into different cells
so paste in formula bar