$14$

You want to create a named array for a list of product codes and use this named array in a VLOOKUP function to find corresponding product descriptions. How should you set up the named array and use it in your VLOOKUP formula?

eBook

References

Multiple Choice

Use $=$ VLOOKUP$($A$2,$ $A$$1$:$B$$10,2,$ FALSE$)$ without naming the list

Define a named array for the product descriptions and use $=$ VLOOKUP$($A$2,$ Descriptions, $2,$ FALSE$)$

Define a named array for the list of product codes, then use $=$ VLOOKUP$($A$2,$ ProductCodes, $2,$ FALSE$)$

Define the named array in a separate workbook, then use $=$VLOOKUP$($A$2,$ 'WorkbookName.xIsx'!Descriptions, $2,$ FALSE$)$