Formula to Lookup Information

[itsmecassiec]

I have an excel database of survey information, and I want to determine the top questions with the lowest results, but return the actual Question in text format, rather than the value. I'm using the Small/Large formula to determine the numbers, but can't figure out how to match it with the question row 1.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Term[/TD]
[TD]Region[/TD]
[TD]Campus[/TD]
[TD]Department[/TD]
[TD]Manager[/TD]
[TD]Overall[/TD]
[TD]Question1[/TD]
[TD]Question2[/TD]
[TD]Question3[/TD]
[TD]1st Lowest[/TD]
[TD]2nd Lowest[/TD]
[TD]3rd Lowest[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]Fall[/TD]
[TD]San Antonio[/TD]
[TD]CampusName 1[/TD]
[TD]Transportation[/TD]
[TD]ManagerName1[/TD]
[TD]4.5[/TD]
[TD]4.1[/TD]
[TD]4.0[/TD]
[TD]4.6[/TD]
[TD]4.0[/TD]
[TD]4.1[/TD]
[TD]4.6[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]Fall[/TD]
[TD]Austin[/TD]
[TD]CampusName 2[/TD]
[TD]Transportation[/TD]
[TD]ManagerName2[/TD]
[TD]4.3[/TD]
[TD]4.2[/TD]
[TD]3.1[/TD]
[TD]3.5[/TD]
[TD]3.1[/TD]
[TD]3.5[/TD]
[TD]4.2[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]Fall[/TD]
[TD]San Antonio[/TD]
[TD]CampusName 3[/TD]
[TD]Facilities[/TD]
[TD]ManagerName3[/TD]
[TD]4.1[/TD]
[TD]4.5[/TD]
[TD]4.2[/TD]
[TD]3.8[/TD]
[TD]3.8[/TD]
[TD]4.2[/TD]
[TD]4.5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1st Lowest[/TD]
[TD]4.1[/TD]
[TD]4.1[/TD]
[TD]3.1[/TD]
[TD]3.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2nd Lowest[/TD]
[TD]4.3[/TD]
[TD]4.2[/TD]
[TD]4.0[/TD]
[TD]3.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3rd Lowest[/TD]
[TD]4.5[/TD]
[TD]4.5[/TD]
[TD]4.2[/TD]
[TD]4.6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[itsmecassiec]

I added 3 columns at the end and used IF formulas to show the questions tied to the value. My only concern now would be duplicates in the values and having a discrepancy when the question is displayed. It only shows the first question it comes across.

The actual data has 13 questions and 64 rows of data. Any assistance is appreciated. Thank you.

 

[PaddyD]

Hi - welcome to the board.

Given the data you've posted, what are your expected results?

 

[ryan0521]

Where's the questions?

 

[itsmecassiec]

If results are identical for two different questions, how can I prevent the formula from returning the first question it comes across twice.

Example of formula returning questions based on ranking:
=IF(V22=H22,$H$1,IF(V22=I22,$I$1,IF(V22=J22,$J$1,IF(V22=K22,$K$1,IF(V22=L22,$L$1,IF(V22=M22,$M$1,IF(V22=N22,$N$1,IF(V22=O22,$O$1,IF(V22=P22,$P$1,IF(V22=Q22,$Q$1,IF(V22=R22,$R$1,IF(V22=S22,$S$1,IF(V22=T22,$T$1,"None")))))))))))))



[TABLE="width: 1637"]
<colgroup><col span="13"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]At work, my opinions seem to count. [/TD]
[TD="align: right"]The mission/purpose of my organization makes me feel like my job is important. [/TD]
[TD="align: right"]My fellow employees are committed to doing quality work. [/TD]
[TD="align: right"]I have a best friend at work. [/TD]
[TD="align: right"]In the last six months, someone at work has talked with me about my progress. [/TD]
[TD="align: right"]In the last year, I have had opportunities to learn and grow. [/TD]
[TD]Rank Lowest[/TD]
[TD]Rank Lowest[/TD]
[TD]Rank Lowest[/TD]
[TD]Lowest[/TD]
[TD]2nd Lowest[/TD]
[TD]3rd Lowest[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3.20[/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]3.70[/TD]
[TD="align: right"]3.20[/TD]
[TD="align: right"]3.50[/TD]
[TD="align: right"]3.90[/TD]
[TD="align: right"]3.20[/TD]
[TD="align: right"]3.20[/TD]
[TD="align: right"]3.50[/TD]
[TD]At work, my opinions seem to count. [/TD]
[TD]At work, my opinions seem to count. [/TD]
[TD]In the last seven days, I have received recognition or praise for doing good work. [/TD]
[/TR]
</tbody>[/TABLE]