@ How to match Two condition & show value ???? via formula

[krunal123]

@ How to match Two condition & show value ???? via formula


1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA ,

And Get Result After match 1st table

 

[RoryA]

You could use:

=IFERROR(FILTER($C$4:$C$8,($A$2:$A$8=F4)*($B$2:$B$8=G4)),"")

assuming there will only be one match per row.