I have two excel worksheets containing corresponding data, that map 1:1 onto each other. I'm trying to build a search box on a third sheet whereby a user can enter a string in cell A2, and cell B2 will find that sting the first sheet, and display the corresponding value from the same cell on the second sheet.
Any ideas? I've been looking at some combination of the CELL and MATCH functions, but MATCH appears to only work with single columns, and I need to search a whole table.
Edit: The strings in the table on the first sheet are unique.