I am looking for an excel formula to get the result. Data is provided in below table
There are 3 criteria based on which a single value needs to pick automatically.
criteria 1 = value 1 variable
criteria 2 = value 2 variable
criteria 3 = value 3 variable
I need a formula which will give me answer by considering all three criteria
I have attached the excel sheet with sample data for better understanding of my problem
Your expert help is really helpful. I have tried the fusion of lookup with index function but i haven't got the desired result.
Bookmarks