What would you enter in each of the following fields in the dialog box for the formula needed in Cell F2 in the SpecialOrder worksheet to obtain the most recent contribution margin per pack for the model in Row 2? Make the cell references in the Table_array field absolute references. 

a. Lookup_value 

b. Table_array 

c. Col_index_num 

d. Range_lookup

Answer rating: 100% (QA)

option A is right VLOOKUP can be slow especially when doing a text ... View the full answer