Hello,
Here is what I am trying to achieve.
When I copy the formula 2 cells to the left (from D to F), I then need the table array to move by 10 columns (from I:L to S:U).
D5 =VLOOKUP($A5,I:L,4,0)
F5 =VLOOKUP($A5,S:U,4,0)
I guess I should use OFFSET but I don't know how.
Thank you for your help.
A sample workbook would be helpful, see instructions for uploading one at the top of the post.
another thing, in F5 =VLOOKUP($A5,S:U,4,0) you are looking to match A5 in column S, the columns to follow are T, U and V - V would be the 4th column over which your formula shows but you only include columns through U which is 3 over so that formula will not work.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Another option might be to use INDEX/MATCH to ID the columns you need (hard to say without seeing a sample WB though)
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
A solution with OFFSET: Please try in D5 and copy to F5:Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks