IF Else Conditions on cell which has formula

pranavk · Jan 13th 2021

Requesting help

Please can someone suggest how to put an If Else condition on cell which is populating values based formula. I cant get rid of formula

if it was simple text following code should have worked

Code

If Not Sheet.columns(AB).Find(what:= "Nine") is Nothing Then
Msgbox "Found"
Else
Msgbox "not found"
End If

but here my problem is that column AB is not text, value "Nine" is displayed as result of Vlookup formula and i have to keep the formula there in this column.

Kindly share your valuable inputs

**royUK** · Jan 14th 2021

Is it returning that Text?

An examplw workbook would help.

pranavk · Jan 15th 2021

no it is not and i am not able to get my personal computer online, i ll post the sheet soon

thanks

**royUK** · Jan 15th 2021

If t is not returning "Nine" then the the code will not find anything.

**Carim** · Jan 17th 2021

Hello,

Have you tested

Code

Sub Test()
If Not Sheet1.Columns("AB").Find(what:="Nine") Is Nothing Then
MsgBox "Found"
Else
MsgBox "not found"
End If
End Sub

Hope this will help

**Carim** · Jan 17th 2021

Feel free to share your comments ...

pranavk · Thursday, 11:51 pm

Sorry for late response, i created a temp column with values then used the find formula there to make it work. As the original column had formula instead of values. When its values in column then find works like charm.

Thank you for your inputs My Roy and Mr Carim

Regards

Pranav

**Carim** · Friday, 7:08 am

Glad you have manged to sort it out

Thanks for your Thanks

Share