ExcelEddie
New Member
- Joined
- Feb 18, 2013
- Messages
- 22
Hi Team,
Sample Table:
A B C D
1 Ref. No. Name Area Comment
2 123456 John Area 1 Comment 1
3 123456 John Area 2 Comment 2
4 123456 John Area 1 Comment 3
5 123564 Mary Area 2 Comment 3
Outside of the above table I have data showing that of columns A, B and C in drop down boxes if that helps.
Can I pull Comment 2 cell ref (D3) from the above example table using a mix of Index and Match (Office 365) or is there another way?
Thank you in advance people.
Sample Table:
A B C D
1 Ref. No. Name Area Comment
2 123456 John Area 1 Comment 1
3 123456 John Area 2 Comment 2
4 123456 John Area 1 Comment 3
5 123564 Mary Area 2 Comment 3
Outside of the above table I have data showing that of columns A, B and C in drop down boxes if that helps.
Can I pull Comment 2 cell ref (D3) from the above example table using a mix of Index and Match (Office 365) or is there another way?
Thank you in advance people.