in sheet Outstanding range c3, type this formula
copied down![]()
=IFERROR(IF(INDEX('Fork lifts'!$C$3:$V$11,MATCH($A3,'Fork lifts'!$A$3:$A$11,0),MATCH($B3,'Fork lifts'!$C$1:$V$1,0))=0,"",INDEX('Fork lifts'!$C$3:$V$11,MATCH($A3,'Fork lifts'!$A$3:$A$11,0),MATCH($B3,'Fork lifts'!$C$1:$V$1,0))),"")
please see attached file
Bookmarks