Help with if then query

[LanceParks]

i All,
In English, I want to populate the cell J4 based on the table value (see attached image)

If cell IA = WDDS the populate with table WDDS value 6:00
If cell IA = WDAS the populate with table WDAS value 12:00
If cell IA = WDNS the populate with table WDNS value 20:00
If cell IA = WEDS the populate with table WEDS value 8:00
If cell IA = WENS the populate with table WENS value 20:00
If cell IA = SAL the populate with table SAL value 8:00



Thanks in advance

 

[FormR]

Hi, welcome to the board!

You could try:
=INDEX($E$4:$E$9,MATCH(I4,$F$4:$F$9,0))

 

[LanceParks]

Thanks FormR, life saver