WinteE
Well-known Member
- Joined
- Apr 8, 2007
- Messages
- 605
I've seen the question for a multiple lookup several times on this forum.
Code and example on www.excelguide.eu
Code and example on www.excelguide.eu
yeah...so wat is mlookup() ? and which language is the above link ? We understand only english here.
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