this will give you what you need, buty you will need to changethe references if your range on the data sheets change..
=VLOOKUP(A2,INDIRECT(A1&"!A2:e14"),2,FALSE)
Change the ,2, to 3...4 as needed
this will give you what you need, buty you will need to changethe references if your range on the data sheets change..
=VLOOKUP(A2,INDIRECT(A1&"!A2:e14"),2,FALSE)
Change the ,2, to 3...4 as needed
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks