Multiple filters used from different tables using apply map

[sakshikaul]

Dear All,

I have an excel which is maintained by user manually. It is having  columns for eg dealer code, manufacturer_ name.

Now i want this manufacturer should map against the dealer code so this could be done with the help of using apply map function.

like:- table1:

mapping load Dealer code

manufacturer_name 

so i simply  will use apply map('table1',Dealer code,'NA') to get the above required condition 

but what if my mapping load will have more than 2 columns for eg :- I have dealer code, manufacturer_name,service_no etc 

How to use apply function in this case?

what is the alternative to implement the same ?

@sunny_talwar  and @Anil_Babu_Samineni   Please help its urgently required 

[Vegar · Accepted solution]

You need to remove the single quote (') after [Claim type]