. For ex. in excel A , i have ZXRC=1, in excel B wherever i find ZXRC, i have to update 1 in next column.... its like UPDATE query in SQL...how to proceed

@badita @vvaidya

@Venkat1991 Before posting check the forum if post is not there than you can post.

Refer below post

I guess both requirement are different. I already checked those queries before posting. Anyway thanks for notifying once again. The value in main excel, can lie anywhere for instance in A23,A54 etc… and can be repetitive too… And moreover excel contains morethan 10k rows, and all should be in same order…