Dear All,
Please find the attached file.
Book 2 there is 4 columns ie,reg no,fleet no,product & model and on book 1 there is fleet no,reg no and model and what i need is to capture fleet no & model from Book 1.
thanks in advance
Regards,
mikello
Dear All,
Please find the attached file.
Book 2 there is 4 columns ie,reg no,fleet no,product & model and on book 1 there is fleet no,reg no and model and what i need is to capture fleet no & model from Book 1.
thanks in advance
Regards,
mikello
Last edited by mikello; 10-22-2009 at 05:13 AM.
See INDEX/MATCH functions in XL Help, eg based on your sample file:
Book2!B2: =INDEX(Book1!$A$5:$A$20,MATCH($A2,Book1!$B$5:$B$20,0))
copied down
same applied to Column D but change INDEX range from Book!A5:A20 to Book1!D5:D20 given you wish to return Model rather than Fleet.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks dear friend.
Regards,
mikello
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks