Hello All,
See attached. In Sheet3, Column BC, I am trying to input a formula that will return the value in Sheet2 column J based on the following match:
Match 1
Sheet3 column K matches Sheet2 column F
Match 2
Sheet3 column CD matches Sheet2 column B
Match 3
Once the above matches have been made, I need the formula to search for "CONLAB" "FULLSC" and "INST" In Sheet2 Column G. If it finds one of these three for the corresponding site ID, it should return the info in row J.
Caveat
If it makes all of the above matches but there is a duplicate entry (see Sheet2 rows 8/9. The Site # is listed twice), it should return the word “Duplicate”.
Does this make sense?
Bookmarks