ROCORD A VARIANCE USING VLOOKUP OR CNDTL.FRMT
Closed
SAM
-
17 Feb 2010 à 14:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Feb 2010 à 15:03
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Feb 2010 à 15:03
Related:
- ROCORD A VARIANCE USING VLOOKUP OR CNDTL.FRMT
- Iserror function in excel with vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Vlookup compare two columns and return a third - Excel Forum
- Copying Excel data from one sheet to another based upon contents of a cell - Excel Forum
- How to use vlookup to match data from different sheets - Office Software Forum
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Feb 2010 à 14:20
17 Feb 2010 à 14:20
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Feb 2010 à 14:43
17 Feb 2010 à 14:43
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Feb 2010 à 15:03
17 Feb 2010 à 15:03
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
