hey guys,
I'm having trouble writing fitting all the conditions i need into a formula. I attached a sample file. the idea is to find the letter from sheet2 on sheet1 and paste the earliest of the two dates in the cell next to it. It seems simple to test for which dates is smaller and just put that, but if a date cell is blank, i need the formula to recognize the cell is blank and not pick it. Also, if both cells are blank, I need it to return "" and not 0. I was able to the blank-check to work for 1 column via index match match and if else, but i can't figure out how to do it for both and have the "" as well.
Any advice?
Thanks.
Bookmarks