Need help on vlookup macro with multiple criteria

[Prashant Satpute]

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.

 

[Somendra Misra]

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)

 

[prasaddn]

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

 

[Prashant Satpute]

Thanks Somendra and Prasad .. Both ideas are good and working for me..