Forum Discussion
Help with IF function
I am trying to create a spreadsheet to track allowed vacation time for employees. I would like column F to contain a formula that will return the correct number of vacation days for an individual emp...
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
=INDEX($K$2:$K$38,MATCH(1,(C2=$I$2:$I$38)*(D2=$J$2:$J$38),0))