hello all,
Normally I would use Index/Match but I'm looking for a VBA solution.
In column A I have a list of numbers.
In column B I have a list of names.
In column C I have a date.
Can a scripting dictionary have 2 keys (in column A & B) and 1 item (in column C)? Match the value in columns A & B and retrieve date value in column C?
Thank you
Normally I would use Index/Match but I'm looking for a VBA solution.
In column A I have a list of numbers.
In column B I have a list of names.
In column C I have a date.
Can a scripting dictionary have 2 keys (in column A & B) and 1 item (in column C)? Match the value in columns A & B and retrieve date value in column C?
Thank you