May 12 2020 11:20 PM - edited May 12 2020 11:35 PM
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
May 13 2020 12:49 AM - edited May 13 2020 12:53 AM
@LanceP In J4, that could be:
=INDEX(E4:E9,MATCH(I4,F4:F9,0))
or
=XLOOKUP(I4,F4:F9,E4:E9,"",0)
if your Excel version supports XLOOKUP
May 13 2020 01:59 AM
This can be done by using INDEX MATCH function.
=INDEX(E4:E9,MATCH(I4,F4:F9,0))
Make sure you extend the data range in case more records are added. Hope this helps.
May 13 2020 02:38 AM
What's the difference with @Riny_van_Eekelen suggestion?
May 13 2020 02:43 AM
Nothing. I just saw the XLOOKUP thing. Missed the above point.