MLOOKUP() - Function for multiple LookUp

[WinteE]

I've seen the question for a multiple lookup several times on this forum.

Code and example on www.excelguide.eu

 

[Stormseed]

yeah...so wat is mlookup() ? and which language is the above link ? We understand only english here.

 

[NBVC]

yeah...so wat is mlookup() ? and which language is the above link ? We understand only english here.

There is a dropdown that lets you select English...

If you then click the Excel button, you can further click Mlookup and read about it. It is a UDF function.

 

[Domski]

Stormseed, you can use the drop down on the left to change from Dutch (Nederlands) to English.

Personally I prefer just to create a unique key by concatonating the columns that I wish to search and then use a combination of index and match to return the values that I require, this has the advantage of being able to specify exact or nearest matches.

Dom

 

[WinteE]

Most Excel users aren't that familiar with INDEX and MATH functions, they're just looking for one clear function.

 

[Stormseed]

Dear Domski,

It is very true that one should follow that concept you defined here using index(match()). However, this can cause discrepancies the reason being possible data duplication. Also, you cannot implement this concept on entirely seperate values in 2 different columns. Moreover, in order to find the nearest values in a lookup, I wud rather make use of the "TRUE" or "1" expression for retrieving column field in the formula.

Dear NBVC & Others:

thanks for the clarification you provided. I checked out the UDF. However, I cannot figure out the use of the UDF in order to achieve my needs. Check this thread and kindly let me know if I can implement this UDF to accomplish my need !

THREAD LINK:
http://www.mrexcel.com/board2/viewtopic.php?t=274770&start=10

 

[WinteE]

Hi Stormseed,

This function only works on columns of the same length, it works the same way the SUMIF() function does.

Guess you can solve this by just using IF(OR(VLOOKUP(),VLOOKUP()),,).

Erik

 

[Stormseed]

Hi Stormseed,

This function only works on columns of the same length, it works the same way the SUMIF() function does.

Guess you can solve this by just using IF(OR(VLOOKUP(),VLOOKUP()),,).

Erik

thanks for your time to read out my thread, Erik

I know it can be achieved using the OR function. However, I am on a hunt of identifying a function which can do multiple lookups alike MLOOKUP() mentioned here

 

[WinteE]

I'll look at it after work's done, in about 7 hours.

 

[WinteE]

Stormseed,

Can you add a screenshot of a short Excelexample to a post ?

- Data on sheet A
- Data on sheet B
- What should be the result
- Where do you want the result

Erik