Selection.Value = [Index((F2:F34),Match(K2&K3,A2:A34&B2:B34),0)]
or
Selection.Value = Evaluate("Index((F2:F34),Match(K2&K3,A2:A34&B2:B34),0)")
Selection.Value = [Index((F2:F34),Match(K2&K3,A2:A34&B2:B34),0)]
or
Selection.Value = Evaluate("Index((F2:F34),Match(K2&K3,A2:A34&B2:B34),0)")
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote