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
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