Relative Content

Tag Archive for excelsearchexcel-formula

Excel: Is there a way for me to use formulas to return the value in a cell using a specific type of two-step search in another sheet?

Suppose I have an Excel file with multiple sheets, and on the main sheet the user can type in a year and a name. I would like to create a formula that returns a code assigned with that name under that year. However, it is not as simple as a 2D table, as neither the names nor the codes are consistent across different years. Instead, every two columns in the second sheet are for each year, and each row is a different person. The left cell is their name and the right cell is their code.