Jagat Pavasia
Active Member
- Joined
- Mar 9, 2015
- Messages
- 359
- Office Version
- 2021
- Platform
- Windows
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
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
Last edited: