1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

# Vlookup and Is number Formula using Vba code

Discussion in 'VBA Macros' started by Dinesh_Excel, Jan 12, 2019.

1. ### Dinesh_ExcelMember

Messages:
145
Hello Friends,

Need help on running the below formula on columns CE and CF and CG using Vba.
The range is dynamic in nature and not constrained to constant.

Appreciate your help on the same.

CE =VLOOKUP(AK2,'Country – Service HUB'!A:C,3,0)
CF =VLOOKUP(AK2,'Country – Service HUB'!A:B,2,0)
CG =IF(ISNUMBER(FIND("I",A2)),"Internal","External")

File size:
30.8 KB
Views:
2
2. ### Dinesh_ExcelMember

Messages:
145
HI All,

I am getting the following error while trying to enter a formula using vba.

Messages:
4,645

File size:
30.5 KB
Views:
1
4. ### Dinesh_ExcelMember

Messages:
145
Thanks Vletm..for highlighting the error.
I could manage to crack the requirement for most of the scenarios but could not able to get the formula ....=IF(ISNUMBER(FIND("I",T2)),"Internal","External") in colunm CG.

The reason for the getting it to run through vba is one of the requirement where it should automatically populate while there is a change in range.

Attaching reference updated sheet.

File size:
41.7 KB
Views:
0
5. ### vletmExcel Ninja

Messages:
4,645
Dinesh_Excel
I see ...
You skipped my hints
as well as
my given solutions.

You wrote:
The reason for the getting it to run through vba is one of the requirement where it should automatically populate while there is a change in range.