Question 42: Match each argument within a lookup function with its best description. Lookup value Table array Column index number Range lookup Optional logical value that specifies a search for an...

Optional logical value that specifies a search for an exact or approximate value in the table array

Column number in a table array that contains the corresponding data to be retrieved

The cell range containing the lookup table

Value in the worksheet to be looked up in the first column of the table array