I have a data table on excel. It is attached. (Sheet1) Pa and Pb are my probability values and I want to extract each Pmax values (J column) that matches with these probabilities. I have a table on the right and for example, at the left up corner I want excel to print the P max value where where Pb=0.01 and Pa=0, and so on. What is the easy way to do it?
Also, each P max value has a reference code on the right. (K column). I want to color each Pmax value according to its reference. For example, Red for 1 and green for 2. (There is an example on sheet2, I did everything by hand and takes a long time)
Any help is appreciated. Thank you in advance.
Bookmarks