I have excel file with 1000+ rows wich contains with 63 unique ATM id, and for every atm i have to write branch id .that is, for each unique ATM id, i have to add the branch id
If you have branch ID available in the same excel, and if you need to populate the branch ID based on some conditions, why don’t you use vlookup?
thanks for advice, ill check documentation and give feedback)
Vlookup not suitable because branch id are in another file(
first file contains more than 1000 rows, next to ATM field I need to fill in the column with the corresponding branch id from second file
there are 13 branch id for 63 atm id
so basically branch id is in other excel right
sorry there are confidence info
ok, Thanks!
here you go with a complete example
New folder.zip (19.2 KB)
kindly incorporate same type of logic in your process as well
thanks
thanks a lot, u r my hero!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.