Hi i want to retrieve date as output based on 2 inputs.Excel attached.
Help is highly appreciated.
Input 1 Input 2
5S Training H1B
Output
01-01-2019
Hi i want to retrieve date as output based on 2 inputs.Excel attached.
Help is highly appreciated.
Input 1 Input 2
5S Training H1B
Output
01-01-2019
How about
=INDEX(F2:F4,MATCH(B9&"|"&C9,INDEX(B2:B4&"|"&E2:E4,0),0))
But the value in B9 is 5S (no space) whereas the values in B2:B3 are 5 S (space in between) for the above formula to work, they must be the same.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks