• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup and Match function problem?

SONJOE JOSEPH

SONJOE JOSEPH

Member
Dear All Excel Experts,

In my attached excel sheet in "Sheet 2" you will find the strike price as 9500 CE. This values changes as and when the user changes the strike price. In this problem say the user changes the strike price to 9500 CE then i want Delta, Theta and Vega values which are in sheet 1 to be copied to "Sheet 2" in the necessary cells.

Do help me all the experts to all the issue.

Regards,

Sonjoe Joseph
 

Attachments

  • LookMatch.xlsx
    10.2 KB · Views: 9
Hi there :)

You can either use VLOOKUP or INDEX/MATCH in array form for this... just remember to complete with CRTL+SHIFT+ENTER (instead of just ENTER).

Hope this helps
 

Attachments

  • LookMatch.xlsx
    11.8 KB · Views: 14
PCosta87 said:
Hi there :)

You can either use VLOOKUP or INDEX/MATCH in array form for this... just remember to complete with CRTL+SHIFT+ENTER (instead of just ENTER).

Hope this helps
Click to expand...

Thank You PCosta for your prompt message. Well i checked the Delta and Theta values are correct but Vega for 9500 CE should be 7.92 but yours is showing 0.00. Seems there should be a correction here. Rest all is fine. Do update the correction needed.

Regards,

Sonjoe Joseph.
 
SONJOE JOSEPH said:
Chirayu Thanks a lot for your prompt message. Well same problem for 9500 CE the Vega should be 7.92 but ur's too is 0. Just update the necessary corrections.

Regards,

Sonjoe Joseph
Click to expand...

I put the wrong column in lol. Change "Sheet1!K" to "Sheet1!M" should fix it
 
You must log in or register to reply here.
Back
Top