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