Index function issue

[rayted]

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 to 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.

*update* I can't upload on here for some reason*

Here is the formula on the project planner snapshot sheet (which needs to import the data): =INDEX('AMP Panel actions'!$A$2:$K$41,P9,11) this is currently returning '0' though there is text in the cell it should be pulling from

 

[steve the fish]

Hi. What is in cell P9 in the sheet where the formula is housed?

 

[rayted]

Hi Steve, it's the ID number of the task (on the project planner snapshot sheet)
The far left on the same sheet, has all the IDs and Tasks being pulled from from the AMP panel actions sheet.

You may be able to view the attachment here: https://www.excelforum.com/showthread.php?t=1207499&referrerid=973907

 

[steve the fish]

You would have to use match to do that.

=INDEX('AMP Panel actions'!$A$2:$K$41,MATCH(P9,'AMP Panel actions'!$A$2:$A$41,0),11)

or

=INDEX('AMP Panel actions'!$K$2:$K$41,MATCH(P9,'AMP Panel actions'!$A$2:$A$41,0))

or even:

=VLOOKUP(P9,'AMP Panel actions'!$A$2:$K$41,11,0)

 

[shift-del]

Rayted,

your problem seems to be solved over at excelforum.com since 7:28 AM. Why would you ask the same question here 4 hours later???

 

[rayted]

Thanks Steve. Just got a similar solution on another site, thanks so much

 

[rayted]

Rayted,

your problem seems to be solved over at excelforum.com since 7:28 AM. Why would you ask the same question here 4 hours later???

Appears to be a time difference setting issue - I am new here. Issue got resolved about 20 mins ago. Anyway I need to close this thread but cannot do so (which is why I wasted a further 10 mins)