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 ...
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.
What's the difference with Riny_van_Eekelen suggestion?
Nothing. I just saw the XLOOKUP thing. Missed the above point.
