Merge/Consolidate data in specific columns

Originally Posted by FDibbins

I put this in D2 and copied down...
=IFERROR(INDEX(G:G,MATCH(A2&B2,INDEX($E$1:$E$5&$F$1:$F$5,0),0)),"")
was this what you wanted?

I'm looking for a function or (macro)command that replaces NA in Sheet1, column C with the correct values from Sheet2 by correctly picking (a) the patient number and (b) the right tumor number.

Originally Posted by FDibbins

So what is your expected outcome?

I haven't been successful with anything that I've tried, yet.