Forum Discussion
Need help please on query
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 ...
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