Hi All -
Is there any way we can do lookup on the basis of field value.
in below example one basis of proudct and mapping source we need to perform lookup.
Mapping source has two field ProductID and Product Price
the reason I'm looking for Dynamic solution because mapping source could increase in future like 30 different files.
Product_Name | Product ID | MappingSource | Product price |
Laptop | 111 | C:\Users\r650323\Desktop\mapping\[Mapping001.xlsx]Sheet1 | |
Laptop | 111 | C:\Users\r650323\Desktop\mapping\[Mapping001.xlsx]Sheet1 | |
Book | 222 | C:\Users\r650323\Desktop\mapping\[Mapping002.xlsx]Sheet1 | |
Book | 222 | C:\Users\r650323\Desktop\mapping\[Mapping002.xlsx]Sheet1 |
Solved! Go to Solution.
Done...
here is the solution - I have created one Batch Macro to console all mapping file into one sheet and then "Find and Replce" tool to look.
also if anyone has different solution please post would love to try.
Regards,
Mukesh Y