Excel lookup function...

[Ram Chandran]

Hi Guys,

can anyone pls help me to solve the below mentioned excel work with simple formula.



Thanks in advance,

 

[p45cal]

5 sheets in the attached, each with a different solution. Explanations on each sheet.
Take your choice.

 

[pecoflyer]

@Ram Chandran In the future please post a sample sheet. Pictures are useless to work with. Thx

 

[Ram Chandran]

5 sheets in the attached, each with a different solution. Explanations on each sheet.
Take your choice.

Hi p45cal,

Thank you so much for your kind reply.
It's work awesome. Once again thank you..