We have a real requirement for a function that works like the vlookup in excel. We are dealing with very large sets of data and currently to get what we need, the data needs to be joined with the same worksheet 7 times. This causes the deliverable report to take a very long time to run. Is there any work around for this or do we have to create a custom function to perform this? Please see data example below.
Please sign in to leave a comment.