Excel formula file linked

Solved/Closed
Scott - May 21, 2010 at 11:41 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 22, 2010 at 04:57 PM
http://wikisend.com/download/466894/Check1.xlsx

Their is a description on the file about what i am trying to do. besicly check one value to a list, if its found check another value with a value next to the cell it was found it. confusing i know

Thanks to all the prompt resonses last time.

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
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")
0
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!!
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 22, 2010 at 04:57 PM
See this file

http://wikisend.com/download/442260/Check1.xlsx
0