LinkBack URL
About LinkBacks
yes, you can use something lke shown below. change the references to suite...
=INDIRECT("A"&B17)
this would use the value A and whatever is in B17 (say 3), to return the value in A3
let me know how this works for you?
yes, you can use something lke shown below. change the references to suite...
=INDIRECT("A"&B17)
this would use the value A and whatever is in B17 (say 3), to return the value in A3
let me know how this works for you?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks for your help but i still can't get it to work. The problem is not quite as straight forward as i originally posted as it is part of a vlookup function.
What I want to be ablte do is fill right to achieve the following sequence,
Cell A7 =VLOOKUP(A4,'Abut A SPlates'!$H$40:$K$44,B4,FALSE)
Cell B7 =VLOOKUP(A4,'Abut A SPlates'!$H$46:$K$50,B4,FALSE)
Cell C7 =VLOOKUP(A4,'Abut A SPlates'!$H$52:$K$56,B4,FALSE)
etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks