find value and display cell next to it

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Problem 4
Find text within text 7
Apply Conditional Formatting If Data in More Than 1 Cell Matches 5
I WantTo Get Rid Of #Value 14
Excel 2002: How to condition format rows with empty cells ? 6
Function won't return value in merged cells 5
Greater than less than arguement returning value when text inputte 2
conditional formatting 2

Top