Lookup/Find function in VBA

[Adrae]

Is there a way to invoke a lookup function in VBA.
For example:

For each cell in my selection, I want to look at column A on Sheet2, find the value (it will appear more than once) and if all values in column D of the same row (use of offset) have then same value (not as column A but as eachother), then I want the offset to my selection to be equal to a given value like "test"

I can try to work through the code myself if someone can help me with how to invoke the lookup or find function I need.

Any help is much appreciated. Thanks Adrae

[Al Chara]

Take a look at my response to your other question.

You can also invoke the lookup functions in VBA by using application.worksheetfunction.lookup