New function to do vlookup for multiple columns

[bobaftt]

I found the function below online and wanted to use it however I get a syntax error when I try to use the function. Any ideas whats wrong with the syntax?

Please Login or Register  to view this content.

[DonkeyOte]

Surplus lines need to be removed, below is the same albeit with a different last line:

Please Login or Register  to view this content.

If you assume you have a table of data say in A3:H10 and you want to return contents of column H where A:E match criteria values specified in A1:E1 you would use the UDF as so:

Please Login or Register  to view this content.

But you could of course do the same thing with native formulae, eg:

Please Login or Register  to view this content.

which would be quicker...IMO

The difference would only appear if you had 1+ instances of the 5 matches... the UDF would return the first Match whereas the LOOKUP would by default return the last.... if there's only one match they'd both return the same result.