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

Help required by matching exact data from 2 cells in excel sheet

ansh

New Member
In the attached excel sheet there is item number and batch number which are repeated multiple times.
I need to get PO number from A:E in J after exactly matching B & D
 

Attachments

  • Book1.xlsx
    14.4 KB · Views: 5
Other Options
=FILTER($C$2:$C$31,($B$2:$B$31=H2)*($D$2:$D$31=I2),"NA")
=VLOOKUP(H2&I2,CHOOSE({1,2},$B$2:$B$31&$D$2:$D$31,$C$2:$C$31),2,0)
 
Back
Top