# Might confusion

#### timspin

##### Board Regular
Hi again

I have a set of answers in a list.
I use data validation, list so you can select which answer you want.

Next to the list of answers I have a list of points.

I use lookup to associate the answer in the drop down list to the drop down list and points.

When I select an answer the ideas is I get a point score comming up in a cell.

What actualy happens is much stranger - The number that comes up is not the number in the list - though its a number on the list. It seems that if my answer is "YES" and it should return a 1 it actualy returns 4 which is the point for answer "1-2 weeks."

Any ideas?
Tim

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
It sounds like your lookup is set up to look for answers in sorted order .... which lookup function did you use? If VLOOKUP change the 4th argument to FALSE.

What's your lookup formula, and how is your list arranged? You need to sort the list or use FALSE as the fourth argument for VLOOKUP. Otherwise you will get unexpected results.

HI

I have tried sorting the list both in terms of the answers and the points - and also tried using dlookup with flase as fourth term - no joy - I have attached HTML of spreadsheet so you can see..

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=15><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Book1.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=15><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb605117><INPUT onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' type=button value="Copy Formula" name=btCb942116></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=15><TABLE border=0><TBODY><TR><FORM name=formFb202339><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name=sltNb447362><OPTION value==LOOKUP(D3,M4:M8,N4:N8) selected>F3<OPTION value==LOOKUP(D5,M10:M14,N10:N14)>F5</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==LOOKUP(D3,M4:M8,N4:N8) name=txbFb150492></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">

=VLOOKUP(D10,M10:N14,2,FALSE)

You answers were in the wrong order

As I said, your answers were in the wrong order. VLOOKUP would work better, but here's your stuff in the correct order, using your original formula:
Book3
BCDEFGHIJKLMNO
1
41-2 Weeks delay3
53-4 Weeks delay4
6Less than 1 Week Delay2
7More than 4 Weeks delay5
8Yes1
9
10
Sheet2

Thats the one - much appreciated again Steve - thankyou
Cheers
Tim

Replies
0
Views
815
Replies
6
Views
436
Replies
0
Views
122
Replies
2
Views
323
Replies
2
Views
398

1,196,254
Messages
6,014,269
Members
441,810
Latest member
LouLou1234

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back