Yes it is possible with either Index/Match or Sumproduct, based on what you want returned, text or number,

but no picture below....