Related:
- Excel formula if statement with link
- Excel grade formula - Guide
- Fenix internet on bank statement - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Gamevault download link - Download - Online gaming and betting
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