LinkBack URL
About LinkBacks
Hi
JUst need some assistance with Vlookup, need to show a certain value in the selected cell based on the selected item no. and month.
Please refer to the attached sheet.
Thanks
Hi
JUst need some assistance with Vlookup, need to show a certain value in the selected cell based on the selected item no. and month.
Please refer to the attached sheet.
Thanks
Last edited by pphg; 01-30-2013 at 03:16 AM.
try this...
=INDEX(DATA!$B$3:$E$5,MATCH(MAIN!C2,DATA!$B$3:$B$5,0),MATCH(MAIN!C3,DATA!$B$3:$E$3,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
Formula:
=INDEX(DATA!$C$4:$E$5,MATCH(MAIN!C2,DATA!$B$4:$B$5,0),MATCH(MAIN!C3,DATA!$C$3:$E$3,0))
Your fast
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks