What's wrong with something like this:

=IF(COUNTIF(B1:B100,A1),"high",IF(COUNTIF(C1:C100,A1),"medium",IF(COUNTIF(D1:D100,A1),"low","")))