Updated: Jun 24, 2018
This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down the column to pick a cell entry.
The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the column headings at the top.
The RowToPickFrom is how far down the column the function should look to pick from.
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no.