Hey everybody. I feel like this should be super simple, but I have the flu so I can't think straight.
I can do this with a vlookup + offset, but I am going to implement a data push so users can overwrite the data they've looked up.
Basically, I want to use find or vlookup in vba to locate the value of a range, let's say Sheet1.Range("A1"), in sheet2, then offset... 3 columns to the right and 1 column down, copy that, and paste it to Sheet1.Range("C1").
Any help on how to do this would be greatly appreciated. Thanks a ton.
I can do this with a vlookup + offset, but I am going to implement a data push so users can overwrite the data they've looked up.
Basically, I want to use find or vlookup in vba to locate the value of a range, let's say Sheet1.Range("A1"), in sheet2, then offset... 3 columns to the right and 1 column down, copy that, and paste it to Sheet1.Range("C1").
Any help on how to do this would be greatly appreciated. Thanks a ton.