I am building a log for permit use, when a person gets a permit their information (name, address, phone number, ect) must come from the Master Sheet by use of a reference number. So when the user goes the Daily Sheet all that is needed is a permit number and the info will copy to the Daily Sheet. I have tried VLookup, and Match but may be doing something wrong. Any hints in the right direction would be appreciated.
on sheret 1-1-13, try this, copied down and across...
=IFERROR(INDEX('Master List(do not edit)'!$A$1:$O$22,MATCH($A3,'Master List(do not edit)'!$A$1:$A$22,0),MATCH(B$1,'Master List(do not edit)'!$A$1:$O$1,0)),"")
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
Try this in B2 of the Daily Sheet, then fill right to column O, then fill down as far as you need to go... adjust the number of rows (100 in my formula) to however many rows are in your Master List sheet:
Formula:
Please Login or Register to view this content.
- Moo
Last edited by Moo the Dog; 12-28-2012 at 06:30 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks