I am using the following VBA to concatenate multiple results of Index Match formulas:
Please Login or Register to view this content.
With the following formula:
=Lookup_concat(E2,Sheet2!$D$2:$D$2000,Sheet2!$N$2:$N$2000)
This is working well, however sometimes the N column in sheet2 contains a blank cell. In this scenario I want to return the value in the M column.
Please see attached xlsm.
Like so, adding another parameter to your function:
Please Login or Register to view this content.
With the following formula:
=Lookup_concat(E2,Sheet2!$D$2:$D$2000,Sheet2!$N$2:$N$2000,Sheet2!$M$2:$M$2000)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Amazing, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks