Related:         
- Excel formula if statement with link
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel color formula - Guide
- Fenix internet on bank statement - Guide
- Formula to calculate vat in excel - Guide
2 responses
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
May 21, 2010 at 09:00 AM
    May 21, 2010 at 09:00 AM
                        
                    Could you please upload a sample file with sample data etc on some shared site like https://authentification.site  , http://wikisend.com/  ,  etc and post back here the link to allow better understanding of how it is now and how you foresee.
                
                
            
                        
                    Hi Scott,
So sheet 1 looks like:
And sheet 2 looks like:
Then put the following formula in cell C1 on sheet 2:
Sheet 2 cell C1 will display Error and C2 will display Correct.
Best regards,
Trowa
            So sheet 1 looks like:
11111 250 11112 255 11113 265 11114 400 11115 350 11116 375
And sheet 2 looks like:
11113 255 11113 265
Then put the following formula in cell C1 on sheet 2:
=IF(B1=Vlookup(A1,Sheet1!$A$1:$B$6,2),"Correct","Error")Drag the formula down as far as you need.
Sheet 2 cell C1 will display Error and C2 will display Correct.
Best regards,
Trowa
