Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a spread sheet with Items and sub Items. I would like to know if I can place a letter in another column it can get it to list the sub item number on another page in order
Solved by S. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/08/2018 - 07:38
Hi…Welcome to Got It Pro
User 22/08/2018 - 07:39
Excelchat Expert 22/08/2018 - 07:39
Could you please share your file?
User 22/08/2018 - 07:39
I can't
Excelchat Expert 22/08/2018 - 07:39
is it possible to illustrate some dummy data in the preview sheet on the right?
Excelchat Expert 22/08/2018 - 07:41
So Column A is Item and B is sub-item, is my understanding right?
User 22/08/2018 - 07:42
So I have Section 1, with subsections 1a,1b,1c and so on, in column G I have letters, I would like Rows 14-21 to show sub items only if N of O is used
User 22/08/2018 - 07:43
in order at the bottom if N or O is used
Excelchat Expert 22/08/2018 - 07:44
Where should the N or O be used?
Excelchat Expert 22/08/2018 - 07:44
Please insert the answer that should appear in row 14 to 21 in this example for me to get an idea.
Excelchat Expert 22/08/2018 - 07:46
Are you saying you want only those sub-sections which indicates N or O in Column G?
Excelchat Expert 22/08/2018 - 07:47
ok...got you.
Excelchat Expert 22/08/2018 - 07:47
Let me build the formula. This will be an array formula.
User 22/08/2018 - 07:47
No sub item at the bottom if y is used
User 22/08/2018 - 07:47
Thank you so much
Excelchat Expert 22/08/2018 - 07:48
Excelchat Expert 22/08/2018 - 07:55
Its taking a little longer to process array formula. Please do extend the time when it prompts.
User 22/08/2018 - 07:55
User 22/08/2018 - 08:06
Going to be much longer?
Excelchat Expert 22/08/2018 - 08:06
Sorry about the delay
Excelchat Expert 22/08/2018 - 08:07
I am trying to get both criteria and its kind of erroring out. But this should work. Please give me a little more time.
User 22/08/2018 - 08:07
Ok I have like 5 more mins before I have to leave for work
Excelchat Expert 22/08/2018 - 08:09
ok..if that's the case, I will send the completed file through our support to your email.
User 22/08/2018 - 08:09
awesome thank you so much

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc