Index match - not returning data (for all cells)
Hi there,
I have somehow stumbled my way across to get an index function to work with a project plan.
Please find spreadsheet attached. On the Project Planner snapshot sheet, you will see on the right-hand side (ID) and 'Actions for the next meeting'. Using the relevant ID number, actions for the next meeting are pulled from the first tab (AMP Panel actions). It's not quite pulling through things (see ID no. 11 for example). Any thoughts on this would be much appreciated.
R.
I had a look at the attachment quickly and could not immediately determine where we are supposed to be looking - could you give cell references? There is a lot of data to soft through!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Removed byJt - wrong thread!!
Hi Ali,
Sure. So if we start on the first tab:
AMP Panel Actions, cell K2 has 'Actions for next meeting' pooulated. Moving to the tab 'Project planner snapshot', cell P2 has an ID number (collected from A2 on the same sheet) and to the right of it, should reference the actions for next meeting from K2... however, different IDs have different actions (K2)... unsure if I am over complicating it?
Thanks,
R.
Hi John,
I don't think this was meant for me?
... I posted to wrong thread !!!!
Ah ok! No worries
In Q2
=INDEX('AMP Panel actions'!$K$2:$K$41,MATCH($P2,'AMP Panel actions'!$A$2:$A$41,0))
Copy down
Solved! Awesome sauce. Thanks John.... looks good to me! Thanks so much
Last edited by AliGW; 11-06-2017 at 07:43 AM. Reason: Unnecessary quotation removed.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks