Is it possible to combine MATCH & IF to search an excel sheet

[Callan]

I'm trying sort two spreadsheets conta

 

[Don Guillett]

if(match(dddd),1,2)