MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Hi and top of the day,
I'm a newbie here, so please excuse my kinda silly question.
Anyway, i have a problem with excel formula. Attached is the example of the data that i have in excel.
I have the MW and MC values from which i can make a graph that looks like this.
So what i want to do next is, i want to find the value of pi1, pi2, pi3, and pi4 (which is the y-axis value) by refferring to the value of component 1, component 2, component 3, and component 4 respectively.
I tried using LOOKUP function, but i'm not happy with the given value as it gives the nearest value instead of the exact one.
Can anyone please help me? I really need some help on this. Thanks in advance