Many thanks for your quick answer. Do you have any suggestions how to do
this or could point me to some sample code? Thanks again.T.

"Vijay Chary" wrote:

Hi Teddy ! :) It would be better (easier) to write a macro with .Find instead
of Worksheerfunction.VLOOKUP to do the job.



"Teddy" wrote:

Hi there,
I have a list of phone numbers by country including number, name and
department and saved them in ranges i.e. a1:b20 = Germany range
a30:b55=France etc

In the second sheet I need to pull in the name and department. I have used
Vlookup which works a treat for one country
=VLOOKUP(P1,'Numbers'!Germany,2,FALSE)

However I wonder how to add if country = france etc then lookup that range
etc for all my countries. Should I use a macro? or IF? or place the
different version of the lookup into each country and copy down?

Thanks, Teddy