Vlookup on the last columns for a range

[Dinesh_Excel]

Hi Team,

I have a data where in the range differs from one period to another.
Need your help in vlookup for the last two columns of the data using vba .

The last two new columns should be name as country and region.

Appreciate your help here

 

[AlanSidman]

I think that you need to explain in more detail exactly what you want to happen here. Show us what the results should look like along with an explanation.

 

[Dinesh_Excel]

Thanks AlanSidman,

Need your help in v lookup for the last two columns of the data using vba .
The last two new columns should be name as country and region.

 

[vletm]

Dinesh_Excel
There is a button for You ... press it!
ps. Your sample file has some typos or so, but this would do as You've written.

 

[Dinesh_Excel]

Thanks Vletm...one minor change .The below columns headers will be not be existing in base sheet while copying the extract from other file.

can we insert a header as " country" and "region" along with while running the code.

Thank you.

 

[vletm]

Dinesh_Excel
... minor?
Texts have to written as You've asked! ( Named headers and sheets names. )
Your " country" text isn't there written as You asked!
That's why, I used 'Region'-text to find column
to where the code will overwrite those 'vlookup's.
( I suppose that even 'Country ' and 'Region'-columns are side by side. )
As well as '/IS/C_COD'-text can be 'anywhere' in that sheet.
I haven't test all (im)possible variations.