I have 3 sheets of data. Using IF, VLOOKUP, ISNA/MATCH, I have to create a formula in sheet 3 to find out if the value(A2), exists in either sheet 1, or sheet 2 or both. If the value is in sheet 1 exclusively I need the formula to generate 1, if the value is in sheet 2 exclusively I need the formula to generate a 2, if its in both I need it to generate a 3. Any help would be appreciated.