Look up and if statement

[rlkerr]

I need a formula to look up a value and return an X.
Example:

Lookup "Bolt" in A1 and if it finds "Bolt" then go to D1 and if D1 is not null then return an X. How in the world can I do this?

[Cutter]

Maybe

=IF(AND(A1="Bolt",D1<>""),"X","")

[rlkerr]

That worked, but here is my problem. I need to lookup "Bolt" in column A and if it finds it then if column D is not null the return an X. It may not be on A1 and D1. It maybe on A26 and D26. Does that make since?

[Mordred]

Enter Cutter's solution and drag it down your sheet.