Finding y-axis value

[husnafezaahmad]

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 looked 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

 

[husnafezaahmad]

@husnafezaahmad,

Welcome to the forum.
Please take a minute to read the forum rules, and note the one on cross-posting etiquette, and comply with it. Thank you!

Sorry if i did something that didn't comply with the forum rules and etiquette.
I'll make sure not to repeat the same mistake again