INDEX and IF formula

[Jagat Pavasia]

DEAR SIR,

I have a sheet contain some data in D5:F12
d5:d12 have value
e5:e12 have category
f5:f12 have sub-category

and then i want that
if i type "COST" in E18 then answer should be in from E19 to E31
if i type both in E18="cost" and F18="A" then answer should be also in from E19 to E31
if i blank both E18 and F18 then nothing to do and blank

for more explain i have attached 3 photos,

please give me formula that can i enter into E19 to E31
i am a new in excel

 

[jasonb75]

if the Filter function works for you then you are not using 2019

I hadn't seen 2019 on their profile anyway @Fluff. The details to the left of each post don't appear on mobile browsers. Do you think that will ever be changed?

 

[Fluff]

The details to the left of each post don't appear on mobile browsers.

I didn't know that, but can check if it will (or can be) changed.

 

[jasonb75]

It may well be device specific, Fluff. I've just tried rotating the screen to landscape and it does show up then, but in portrait it is a slimmed down view. I'm doing it on a phone as well so it could also show up normally on tablets with different aspect ratios.

 

[Fluff]

It is part of the design & cannot be changed, however if you touch the logo for a second or two the full profile will appear, although that doesn't show the version unfortunately.

 

[Jagat Pavasia]

Try this one.

=FILTER(D5:D15,IF(E18<>"",E5:E15=E18)*IF(F18<>"",F5:F15=F18,1),"")

IT IS WORKING