Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
the column that contains Product IDs result_array — The third parameter indicates the target column/row, the Sales Person column (E4:E13) in this case After assigning all the values, our LOOKUP function comes out to be: =LOOKUP(K8,B4:B13,E4:E13) The DsExcel code below shows how to use the LOOKUP