Implement LookUp function

[rmfg91]

Read and complete the full issue template

Do you want to request a feature or report a bug?

• [] Bug
• [x ] Feature

If you are logging a possible bug or feature request, please test with the latest development build first.

Version of ClosedXML

v 0.94.2

What is the current behavior?

Reading an Excel cell value wich contains lookup function throws a CellReferenceException since the function lookup is not implemented.

What is the expected behavior or new feature?

I was wondering if anyone was planning on developing that function. I am fairly new to programming and would take me quite some time to implement it.

Did this work in previous versions of our tool? Which versions?

No

Reproducibility

This is an important section. Read it carefully. Failure to do so will cause a 'RTFM' comment.

Without a code sample, it is unlikely that your issue will get attention. Don't be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.

Code to reproduce problem:

public void Main()
{
    // Code standards:
    // - Fully runnable. I should be able to copy and paste this code into a 
    //   console application and run it without having to edit it much.
    // - Declare all your variables (this follows from the previous point)
    // - The code should be a minimal code sample to illustrate issue. The code 
    //   samples on the wiki are good examples of the terseness that I want. Don't
    //   post your full application.
}

• I attached a sample spreadsheet. (You can drag files on to this issue)

[igitur]

Using the LOOKUP function is discouraged, as it requires the data to be sorted, but I will try to implement something.

Please provide real-world examples.

[jahav]

Once the LOOKUP is implemented, the #585 will be also working. Since VLOOKUP has been implemented, it should be pretty simple to reuse bisection logic.