• 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.

Excel formula help

M

Maddy

Member
Hi There,

I am trying to get net price amount on the basis of latest Date on sheet 2. Can somebody please help me with formula to get the desired result.

I have attached the sheet for reference.

Material is common field in both tabs.



need the value in Result tab under ( Purchase Price per Unit (USD) Net Price ).



Thanks,
Mj
 

Attachments

  • Book .zip
    22.3 KB · Views: 13
In Result Sheet B2, copied down :

=IFERROR(LOOKUP(9^9,Sheet1!$C$2:$C$100/(A2=Sheet1!$B$2:$B$100)),"")

Regards
Bosco
 
Dear Bosco,

thanks so much for helping me. just wanted to understand the process if you can as in how does it work.

waiting for your reply
Thanks
 
You must log in or register to reply here.
Back
Top