Offset formula works based on the same worksheet. Can we use this function to get result in Sheet1 based on data at sheet 2
Offset formula works based on the same worksheet. Can we use this function to get result in Sheet1 based on data at sheet 2
You can use it if u use the Indirect function along with it.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
It works for me, like this:
With Sheet2!A1 = "ABC", Sheet2!A2 = "DEF"
In Sheet1, type :
returns "DEF"Please Login or Register to view this content.
Can this reply to your issue?
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks