| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| Find value every time it appears and display cell above | Excel Worksheet Functions | |||
| HOW? Find and display the last cell in a column with a value 0 | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| trying to find how to display worksheet name in cell | Excel Discussion (Misc queries) | |||
Linear Mode
