Vlookup and Is number Formula using Vba code

[Dinesh_Excel]

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")

Attached sheet for your reference.

 

[Dinesh_Excel]

HI All,

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

Appreciate your help

Sub fry3()
Range("A2").Select
Selection.End(xlDown).Select
lastrow = ActiveCell.Row
For I = 2 To lastrow
Sheets("SALE").Range("CG" & CStr(i)).Formula = "=IF(ISNUMBER(FIND("I",T2)),"Internal","External")"
Next I
End Sub

 

[vletm]

Dinesh_Excel
Have You checked You 'CG'-formula at all?
a) A-column is empty!
b) with Your macro ...
if You really need to use 'formula' then recheck 'formula's syntax.
c) after You'll know from which column would solve 'CG',
many thing would be done
d) ... why use that formula?
https://chandoo.org/forum/threads/updating-output-with-first-letter-as-i.40538/

 

[Dinesh_Excel]

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.


Appreciate your help..

Attaching reference updated sheet.

 

[vletm]

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.
You had there formulas and
now You would like use VBA to do same formulas.
What would change?