Re: Comparing to files want to find and identify exceptions
works perfectly thank you...
Re: Comparing to files want to find and identify exceptions
works perfectly thank you...
Re: Comparing to files want to find and identify exceptions
here is data set for each file, I only provided the 3 columns of data that I want to validate...
Re: Auto populating drop down lists/cells based on conditions
have a good evening
Re: Comparing to files want to find and identify exceptions
Ok very I understand ... sorry, I was not sure if I put the thread in the correct forum...
Hello Guru's
I need some help please, I'd like to create one formula that can do the below, I can create the vlookups for each individual function, I would like to see if its possible to combine the validation into one formula.
I have two files I want to compare/validate and identify the exceptions, I want to match the contract number in column F1, vendor number in column f2 and part number in Column f3 to same columns in second file if they match return "Match" if they don't return "new"
Thanks in advance...
Hello Guru's
I need some help please, I'd like to create one formula that can do the below I can create the vlookups for each individual but want to see if its possible to combine the validation into one.
I have two files I want to compare/validate and identify the exceptions, I want to match the contract number in column F1, vendor number in column f2 and part number in Column f3 to same columns in second file if they match return "Match" if they don't return "new"
Thanks in advance...