Lookup/Find function in VBA

Adrae · Apr 4th, 2002, 10:37 AM

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 · Apr 4th, 2002, 11:21 AM

Take a look at my response to your other question.

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

Apr 4th, 2002, 11:21 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Take a look at my response to your other question. You can also invoke the lookup functions in VBA by using application.worksheetfunction.lookup __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 10:37 AM	#1
Adrae Board Regular Join Date: Feb 2002 Location: Chicago, IL USA Posts: 306	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