Thanks dear
but i dont want to use vlookup bcoz it cannot look to the right side of a column and the file is only as a reference and original files have many columns some are to left and some are to right of the base column. So need to use INDEX/MATCH
thanks
|