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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 17, 2010 at 03:03 PM
Related:
- ROCORD A VARIANCE USING VLOOKUP OR CNDTL.FRMT
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Vlookup if cell contains a word within text ✓ - Word Forum
- Vlookup if two cells match return value from third ✓ - Excel Forum
- Vlookup false ✓ - Excel Forum
- Conditional Formatting in a vlookup - Excel Forum
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
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")
=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.
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
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
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...
=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
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
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
