Help with IF function

Copper Contributor

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 employee based on position and years of service. My parameters are in I:K. 

 

KimKE7359_0-1671642752252.png

 

3 Replies

@KimKE7359 

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))

help with if formula.JPG 

This does not work. It returns "#N/A". Also, ctrl+shift+enter does nothing. 

@KimKE7359 

Does ctrl+shift+enter add the curly brackets (highlighted in the screenshot) to the formula? You can click in the formula bar with the mouse and then confirm the formula with ctrl+shift+enter. This adds the " { " and " } " and then the arrayformula returns the result.

curly brackets.JPG