Book2.xlsx (9.4 KB)
I have attached one excel file. Where I am using Excel mapping.
for example : with reference to excel attached
case 1 : if agency is Abaca then in order file , order value will be taken from C5 column. In this case order value will be “jkskd”
case 2 : if agency is Basava then in order file , order value will be taken from H4 cell .In this case order value will be “hsgg”. Here we are finding first cell value for “def” and then we are using offset values mentioned in excel mapping. For all values within inverted comma,
it will be taken as absolute value and we have to use row and column offset value.
We have thousand agencies in such a way.
Based on excel mapping we need to click on cell value and for absolute values (“”) we have to find its cell
address first and using offset values we then need to find final cell value and fetch that data.
Any suggestion will be appreciated.