Posts by Jon_P

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...