Hi,
I am working on my school file.I have 2 set of sheets, one has event schedule and another one got students interest about the event.Based on students interest I need to prepare a sheet which has a event calendar and their preferences.I tried using Vlookup but no luck.I guess I need a Hlookup and Vlookup or a function which I can select a student and its sheets comes as a output.
Attached data with output can explain the scenario better.
Thanks
Is this what you are looking for? Index Match combines a vlookup and hlookup.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
Yes but I have around 500 students.Possible to have a macro to perform the task for 500 students with single click or macro.
Thanks Hawkeye
I am tired of trying again and again
Try this, copied down and across...
=IFERROR(IF($A2="",INDEX(interest!$B$2:$H$6,MATCH(Output!$A1,interest!$A$2:$A$6,0),MATCH(Output!$B1,interest!$B$1:$H$1,0)),INDEX(schedule!$B$2:$M$8,MATCH(Output!$B2,schedule!$A$2:$A$8,0),MATCH(Output!C$1,schedule!$B$1:$M$1,0))),"")
You may need to adjust for the different formats
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
Where do I need to apply this Formula, I mean on which cell ????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks