Conditional format with search, vlookup and named Table

i cant seem to figure this one out. im trying to turn a cell the color red if it meets this condition

i have a table that is connected to the internet so that I can refresh my table to make sure my table is up to date. this table has a couple columns the ones im conserned about are the first column and the 4th column. the first column is an ID and the 4th column is a description.

Then on another sheet in column A I will put in the ID that i need. In column B, I want the the cell in column B to turn red if the description for the corresponding ID contains "AS PER PLAN"
I have tried this and it does not work.

in the conditional formatting box
=SEARCH("*AS PER PLAN*",VLOOKUP(A1,QryItemE13,4,FALSE))

QryItemE13 is the name of the table.

can anyone give a solution??

thanks
JD

Try this formula for your CF:

=ISNUMBER(SEARCH("AS PER PLAN",VLOOKUP(A1,QryItemE13,4,FALSE)))

Hope this helps.

Pete

that didnt work. I think it doesnt like the named table. it keeps telling me there is a problem with the formula.