Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
for a particular Product ID specified in the K8 cell table_array — This parameter represents the target table or cell range that contains the source data to be searched. Let us take B4:E13 as the target range that starts with the Product ID column, which should be the leftmost column_index_num —