Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
this case lookup_array — This parameter represents the column/row range to search for the lookup_value. The product IDs are in the B4:B13 range return_array — The third parameter indicates the range for the target values. D4:E13 is the range that contains the Sales Person and Sales Region columns