Hello Boss.
There are lot sites in my company across the world.What are the sits are ready for dispatch's,every time I use copy and paste method.I need row number based on lookup value.
In Row A2:A21 Country Name,i have enter row number 2 return the name united states.
Please help me.file attached.
Country
United States
China
Japan
Germany
France
Brazil
United Kingdom
Italy
India
Russia
Canada
Australia
Spain
Mexico
South Korea
Indonesia
Netherlands
Turkey
Switzerland
Saudi Arabia
Desired Results.
Desired Results
2 United States
10 India
11 Russia
16 South Korea
18 Netherlands
8 United Kingdom
9 Italy
5 Germany
4 Japan
3 China
15 Mexico
16 South Korea
17 Indonesia
18 Netherlands
Bookmarks