Notifications
Clear all
Topic starter
Hi, based on the attachment, I have a situation whereby I need to return value in column C with specific value in column J, whereby column A&B must match column G&H.
i try using the solution provided in the following link https://www.myonlinetraininghub.com/vlookup-using-dates-multiple-values-in-multiple-columns
but couldn't get the answer as it's return error.
Hope anyone can assist.
Regards.
Khalil
Posted : 03/02/2017 12:42 am
Hi Khalil
See if this is what you are looking for.
Note that this is an array formula so you will need to press CTRL+SHIFT+ENTER (instead of ENTER) to complete the formula.
Hope this helps.
Sunny
Posted : 03/02/2017 9:03 am
