Excel Forum

Hey there i have such data set
A B C D
ITEM PRICE RANGE YEAR DISCOUNT
Fan 20 30 1 5%
Air con 350 495 1 …………… 5 %
TV 500 750 1 … 5%
Fan 20 30 2 4%
Air con 350 495 2 4%
TV 500 750 2 4%
Fan 20 30 3 3%
Air con 350 495 3 3%
TV 500 750 3 3%
i want to look up FAN with Price 25 nd year 1 to find discount ?

please kindly give any solution?

Please attach file. If not, nobody can help you. OK?

see ==> viewtopic.php?f=2&t=1132#p45444

Hi Dear
I can't upload my file

Could you please tell me what is your problem about upload file?

I alway solve this problem with
=index(... : ..., sumifs(... : ...,........))