Excel formula file linked
Solved/Closed
Scott
-
May 21, 2010 at 11:41 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 22, 2010 at 04:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 22, 2010 at 04:57 PM
Related:
- Excel formula file linked
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Windows 10 iso file download 64-bit - Download - Windows
- Excel grade formula - Guide
- We can't recover your account online because there are no other options on file for your account. ✓ - Yahoo Mail Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 21, 2010 at 12:15 PM
May 21, 2010 at 12:15 PM
The most easy way to get to the answer would be
1. Add a new column to CPSCs as
=A2 & "|" & b2
Lets say that you added the above formula in column C of CPSC sheet
in on sheet1 you can have
=if(iserror(vlookup(b2 & "|" & e2, CPSC!C:C, 1, false)), "Mismatch", "Match")
1. Add a new column to CPSCs as
=A2 & "|" & b2
Lets say that you added the above formula in column C of CPSC sheet
in on sheet1 you can have
=if(iserror(vlookup(b2 & "|" & e2, CPSC!C:C, 1, false)), "Mismatch", "Match")
I could not get your way to work, but using your information i made it work, i made the new colum like you said in cpsc, then i made a 4 sheet and put =Sheet1!B2 & "|" & Sheet1!E2, (made a list of the colum named "formula" then i used =IF(ISERROR(MATCH(Extras!A2,formula,0)),"Error","Correct") in sheet1 colum H
so it just compares the 2 values.
Thanks for the help!!
so it just compares the 2 values.
Thanks for the help!!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 22, 2010 at 04:57 PM
May 22, 2010 at 04:57 PM
See this file
http://wikisend.com/download/442260/Check1.xlsx
http://wikisend.com/download/442260/Check1.xlsx
