mtarler Silver Contributor tonyan in your formula you have "TRUE" for range lookup parameter which is doing an approximate match, which probably means you are always getting a match to something in the first sheet. what happens if you use "FALSE" in each case meaning ...