|re: "In another sheet I have a list of calls made to my company from different parts of the world every month in row A."|
A is a Column, not a Row.
re: "I have to place the country name next to the call in sheet B"
I assume you mean Column B, not Sheet B.
A posting tip:
Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum. using that format, I assume you have a list like this:
1 0044 UK
2 0061 Australia
3 0092 Pakistan
4 0064 NewZealand
If that's the case, then put this in Sheet2!B1 and drag it down:
Obviously you'll need to modify the formula to fit your exact ranges.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.