I am using Excel to create a pretty complex database. I am using numbers in one worksheet to reference an ID field from another worksheet. Is there a way that I can enter text into a cell, have that cell compared to a column on a different worksheet and, if there is a match, replace the text I entered with a number from a different column.