find value and display cell next to it

  • Thread starter Thread starter Jambruins
  • Start date Start date
J

Jambruins

I have the following in cells A14:G14
Toronto at N.Y. Yankees 1:05 pm ET

In cell L14 I have N.Y. I would like a formula to find the value in cell
L14 (N.Y.) in cells A14:G14 and display the value next to it (Yankees in this
case). Thanks.
 
Back
Top