ExcelBanter - find value and display cell next to it

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find value and display cell next to it (https://www.excelbanter.com/excel-discussion-misc-queries/181364-find-value-display-cell-next.html)

Jambruins

find value and display cell next to it

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.

dennis

find value and display cell next to it

=INDEX(A14:G14,1,MATCH(L14,A14:G14,0)+1)

"Jambruins" wrote:

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.

Jambruins

find value and display cell next to it

perfect, thanks

"Dennis" wrote:

=INDEX(A14:G14,1,MATCH(L14,A14:G14,0)+1)

"Jambruins" wrote:

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.

All times are GMT +1. The time now is 10:04 PM.