Changing multiple cells depending on another cell in their row
05:46 19 Jan 2022

I have an Excel sheet with two columns. The first column holds names. I also have a list of names as text file, now added as second sheet.

For each row, I want to set the second cell to a fixed value if the value of the first cell is present in the list. Other rows should remain unchanged.

I was told to consider VLOOKUP but could not make up a formula.

I'm using Excel for Microsoft 365

first sheet: enter image description here column M is the one to be changed

second sheet: enter image description here

The expected output would simple have entries in column M to be IN instead of OUT.

excel excel-formula vlookup