Due: Tomorrow, April 7 (8:00pm)
On the course website
The fourth argument in the VLOOKUP function and the third argument in the MATCH function specifies how the searches should be performed.
A "less than" search finds an exact match or (if no exact match is found) the match closest match that is less than the lookup value.
A "less than" search finds an exact match or (if no exact match is found) the match closest match that is greater than the lookup value.
We know binary search looks at the middle element and then discards half the data.
Download the Spreadsheet -- we will use it to show how Excel uses a binary search!