• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help on vlookup macro with multiple criteria

Hi,

I have DM and Account list as in Table2 in attached file and SL mapped wrt DM and account data. I wish to lookup the SL from table 2 in SL column of Table 1.

It should use both DM and Account for mapping. I'm new to Excel macro.

Your help would help me a lot.


Attaching the data file.
 

Attachments

  • mapping_sample.xlsx
    9.5 KB · Views: 4
Hi Prashant,

If you are comfortable with formula, try below formula in F4 and copy down:

=INDEX($M$4:$M$10,MATCH(E4&D4,$K$4:$K$10&$L$4:$L$10,0))

Note this is an array formula, so must be entered with Ctrl+Shift+Enter. (See the file)
 

Attachments

  • mapping_sample.xlsx
    10.1 KB · Views: 10
Hi Prashant,

If you are okay with adding helper columns, add one column in each of the table. The column will have formula to concatenate DM and Account. do the same in Table 2 as well.

After that use vlookup() to fetch the results.

tip: use help column in table 2 on left side of SL column so that vlookup can be used.

Regards,
Prasad DN
 
Back
Top