abdool3002
New Member
- Joined
- May 31, 2015
- Messages
- 2
Hey Guys,
I've been trying to figure out a solution to this all day but I've come up short. I'm pretty sure this will be straight forward for you experts . I've uploaded a snapshot of my sheet below. I have four similarly structured sheets that each include a "REASONS" column and its corresponding records for that reason. I want to create a summary sheet that will include each record number e.g. 7V6VN8, 3D3PS9 and its reason from my four sheets. I'm unsure of how to do this. I need to lookup the record number form the array and return it's reason. Can someone please help. Thank you so much in advance.
I've been trying to figure out a solution to this all day but I've come up short. I'm pretty sure this will be straight forward for you experts . I've uploaded a snapshot of my sheet below. I have four similarly structured sheets that each include a "REASONS" column and its corresponding records for that reason. I want to create a summary sheet that will include each record number e.g. 7V6VN8, 3D3PS9 and its reason from my four sheets. I'm unsure of how to do this. I need to lookup the record number form the array and return it's reason. Can someone please help. Thank you so much in advance.