#### Why #NA when using VLOOKUP?

```This is a multi-part message in MIME format.

Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I'm trying to use VLOOKUP to find lowest value in a small group.  The =
exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm trying to =
get it to return the lowest cost, from column A.  If I take out Row 4, =
it works.  But with Row 4 in it, it returns a value of #N/A, I'm =
guessing from the HELP screen it's because "...lookup_value is smaller =
than the smallest value in the first column of table_array, VLOOKUP =
returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it thru his =
skull?

Thanks,
Jim Dixon
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
<BODY>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest value in a=20
small group.&nbsp; The exact sample is below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" cellSpacing=3D0 =

<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL style=3D"WIDTH: 159pt; mso-width-source: userset; mso-width-alt: =
7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp; =
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>2</STRONG>&nbsp; 2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>3</STRONG>&nbsp; 2.9610 </FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>5</STRONG>&nbsp; 2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it to =
return the=20
lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row <STRONG>4</STRONG> in =
it, it=20
returns a value of #N/A, I'm guessing from the HELP screen it's because=20
"...lookup_value is smaller than the smallest value in the first column =
of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone feels =
like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim Dixon</FONT></DIV></BODY></HTML>

```
 0
jimd2081 (8)
7/16/2007 6:34:00 PM
excel.newusers 15348 articles. 2 followers.

8 Replies
1005 Views

Similar Articles

[PageSpeed] 53

```This is a multi-part message in MIME format.

------=_NextPart_000_0CA5_01C7C7E2.B882BAA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Use

=3DVLOOKUP(MIN(A1:A5),A1:B5,1,FALSE)

--=20
---
HTH

Bob=20

(there's no email, no snail mail, but somewhere should be gmail in my =

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group.  The =
exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm trying =
to get it to return the lowest cost, from column A.  If I take out Row =
4, it works.  But with Row 4 in it, it returns a value of #N/A, I'm =
guessing from the HELP screen it's because "...lookup_value is smaller =
than the smallest value in the first column of table_array, VLOOKUP =
returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it thru =
his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0CA5_01C7C7E2.B882BAA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Use</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>=3DVLOOKUP(MIN(A1:A5),A1:B5,1,FALSE)</FONT></DIV>
<DIV><BR>-- <BR>---<BR>HTH</DIV>
<DIV>&nbsp;</DIV>
<DIV>Bob </DIV>
<DIV>&nbsp;</DIV>
<DIV>(there's no email, no snail mail, but somewhere should be gmail in =
my=20
<DIV>&nbsp;</DIV>
<DIV><BR>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest value in=20
a small group.&nbsp; The exact sample is below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp; =
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>2</STRONG>&nbsp; 2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>3</STRONG>&nbsp; 2.9610 </FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>5</STRONG>&nbsp; 2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it to =
return the=20
lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row <STRONG>4</STRONG> in =
it, it=20
returns a value of #N/A, I'm guessing from the HELP screen it's =
because=20
"...lookup_value is smaller than the smallest value in the first =
column of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone =
feels like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim =
Dixon</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0CA5_01C7C7E2.B882BAA0--

```
 0
bob.NGs1 (1661)
7/16/2007 6:51:37 PM
```This is a multi-part message in MIME format.

------=_NextPart_000_0110_01C7C7E3.1B55A610
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Try it with zero or FALSE as the last argument in the VLOOKUP()=20

If 1 or TRUE is used as the 4th argument then the list needs to be =
sorted in assending order.

--=20
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group.  The =
exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm trying =
to get it to return the lowest cost, from column A.  If I take out Row =
4, it works.  But with Row 4 in it, it returns a value of #N/A, I'm =
guessing from the HELP screen it's because "...lookup_value is smaller =
than the smallest value in the first column of table_array, VLOOKUP =
returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it thru =
his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0110_01C7C7E3.1B55A610
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Try it with zero or FALSE as the last =
argument in=20
the VLOOKUP() </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>If 1 or TRUE is used as the 4th =
argument then the=20
list needs to be sorted in assending order.</FONT></DIV>
<DIV><BR>-- <BR>HTH</DIV>
<DIV>&nbsp;</DIV>
<DIV>Sandy<BR>In Perth, the ancient capital of Scotland<BR>and the =
crowning=20
place of kings</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"mailto:sandymann2@mailinator.com">sandymann2@mailinator.com</A><B=
R>Replace=20
@mailinator.com with @tiscali.co.uk</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest value in=20
a small group.&nbsp; The exact sample is below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp; =
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>2</STRONG>&nbsp; 2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>3</STRONG>&nbsp; 2.9610 </FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>5</STRONG>&nbsp; 2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it to =
return the=20
lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row <STRONG>4</STRONG> in =
it, it=20
returns a value of #N/A, I'm guessing from the HELP screen it's =
because=20
"...lookup_value is smaller than the smallest value in the first =
column of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone =
feels like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim =
Dixon</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0110_01C7C7E3.1B55A610--

```
 0
sandymann2 (1054)
7/16/2007 6:54:22 PM
```This is a multi-part message in MIME format.

------=_NextPart_000_002C_01C7C7B3.3A9B5400
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

To Bob and Sandy, and anyone else who answers this question...MANY, MANY =
THANKS!!!  WHOOPEE!!!  YIPPEE!!!  ...etc. etc. etc.

Now that it works, I can go on, and try to answer my unwritten =
question...why?  No, don't answer it for me, it would ruin all the fun =
I'll have when I have the "Duh!!" moment.

Thanks, Jim Dixon
"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group.  The =
exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm trying =
to get it to return the lowest cost, from column A.  If I take out Row =
4, it works.  But with Row 4 in it, it returns a value of #N/A, I'm =
guessing from the HELP screen it's because "...lookup_value is smaller =
than the smallest value in the first column of table_array, VLOOKUP =
returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it thru =
his skull?

Thanks,
Jim Dixon
------=_NextPart_000_002C_01C7C7B3.3A9B5400
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>To Bob and Sandy, and anyone else who =
question...MANY, MANY THANKS!!!&nbsp; WHOOPEE!!!&nbsp; YIPPEE!!!&nbsp; =
....etc.=20
etc. etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Now that it works, I can go on, and try =
my unwritten question...why?&nbsp; No, don't answer it for me, it would =
ruin all=20
the fun I'll have when I have the "Duh!!" moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks, Jim Dixon</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest value in=20
a small group.&nbsp; The exact sample is below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp; =
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>2</STRONG>&nbsp; 2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>3</STRONG>&nbsp; 2.9610 </FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>5</STRONG>&nbsp; 2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it to =
return the=20
lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row <STRONG>4</STRONG> in =
it, it=20
returns a value of #N/A, I'm guessing from the HELP screen it's =
because=20
"...lookup_value is smaller than the smallest value in the first =
column of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone =
feels like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim =
Dixon</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_002C_01C7C7B3.3A9B5400--

```
 0
jimd2081 (8)
7/16/2007 7:11:37 PM
```This is a multi-part message in MIME format.

------=_NextPart_000_0094_01C7C7E6.D72B1980
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

>when I have the "Duh!!" moment.

Like when you figure out that all you need is:

=3DMIN(A1:A5)

--=20
Biff
Microsoft Excel MVP

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl...
To Bob and Sandy, and anyone else who answers this question...MANY, =
MANY THANKS!!!  WHOOPEE!!!  YIPPEE!!!  ...etc. etc. etc.

Now that it works, I can go on, and try to answer my unwritten =
question...why?  No, don't answer it for me, it would ruin all the fun =
I'll have when I have the "Duh!!" moment.

Thanks, Jim Dixon
"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group.  =
The exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm =
trying to get it to return the lowest cost, from column A.  If I take =
out Row 4, it works.  But with Row 4 in it, it returns a value of #N/A, =
I'm guessing from the HELP screen it's because "...lookup_value is =
smaller than the smallest value in the first column of table_array, =
VLOOKUP returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it thru =
his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0094_01C7C7E6.D72B1980
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.3086" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&gt;when I have the "Duh!!" =
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Like when you figure out that all you =
need=20
is:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3DMIN(A1:A5)</FONT></DIV>
<DIV><BR>-- <BR>Biff<BR>Microsoft Excel MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl">news:udWHfz9xHHA.748@T=
K2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>To Bob and Sandy, and anyone else who =
this question...MANY, MANY THANKS!!!&nbsp; WHOOPEE!!!&nbsp; =
YIPPEE!!!&nbsp;=20
...etc. etc. etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Now that it works, I can go on, and =
my unwritten question...why?&nbsp; No, don't answer it for me, it =
would ruin=20
all the fun I'll have when I have the "Duh!!" moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks, Jim Dixon</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest value=20
in a small group.&nbsp; The exact sample is below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: =
12.75pt; BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp;=20
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; =
BACKGROUND-COLOR: transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT=20
face=3DArial><FONT size=3D2><STRONG>2</STRONG>&nbsp;=20
2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT=20
face=3DArial><FONT size=3D2><STRONG>3</STRONG>&nbsp; 2.9610=20
</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT=20
face=3DArial><FONT size=3D2><STRONG>5</STRONG>&nbsp;=20
2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it to =
return the=20
lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take out Row =

<STRONG>4</STRONG>, it works.&nbsp; But with Row <STRONG>4</STRONG> =
in it,=20
it returns a value of #N/A, I'm guessing from the HELP screen it's =
because=20
"...lookup_value is smaller than the smallest value in the first =
column of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone =
feels like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim=20
Dixon</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0094_01C7C7E6.D72B1980--

```
 0
biffinpitt (3172)
7/17/2007 12:21:06 AM
```This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C7C84D.BE7E6560
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I did know MIN would work, what I left out was I also wanted the value =
associated with the lowest cost, from column B, so I was using a VLOOKUP =
for both of them.  But thanks, nonetheless, I appreciate your and =
everyones help.
Jim

"T. Valko" <biffinpitt@comcast.net> wrote in message =
news:uaAFghAyHHA.1164@TK2MSFTNGP02.phx.gbl...
>when I have the "Duh!!" moment.

Like when you figure out that all you need is:

=3DMIN(A1:A5)

--=20
Biff
Microsoft Excel MVP

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl...
To Bob and Sandy, and anyone else who answers this question...MANY, =
MANY THANKS!!!  WHOOPEE!!!  YIPPEE!!!  ...etc. etc. etc.

Now that it works, I can go on, and try to answer my unwritten =
question...why?  No, don't answer it for me, it would ruin all the fun =
I'll have when I have the "Duh!!" moment.

Thanks, Jim Dixon
"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group.  =
The exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm =
trying to get it to return the lowest cost, from column A.  If I take =
out Row 4, it works.  But with Row 4 in it, it returns a value of #N/A, =
I'm guessing from the HELP screen it's because "...lookup_value is =
smaller than the smallest value in the first column of table_array, =
VLOOKUP returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it =
thru his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0009_01C7C84D.BE7E6560
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I did know MIN would work, what I left =
out was I=20
also wanted the value associated with the lowest cost,&nbsp;from column =
B, so I=20
was using a VLOOKUP for both of them.&nbsp; But thanks, nonetheless, I=20
<DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"T. Valko" &lt;<A=20
href=3D"mailto:biffinpitt@comcast.net">biffinpitt@comcast.net</A>&gt; =
wrote in=20
message <A=20
=
href=3D"news:uaAFghAyHHA.1164@TK2MSFTNGP02.phx.gbl">news:uaAFghAyHHA.1164=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>&gt;when I have the "Duh!!" =
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Like when you figure out that all you =
need=20
is:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3DMIN(A1:A5)</FONT></DIV>
<DIV><BR>-- <BR>Biff<BR>Microsoft Excel MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl">news:udWHfz9xHHA.748@T=
K2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>To Bob and Sandy, and anyone else =
this question...MANY, MANY THANKS!!!&nbsp; WHOOPEE!!!&nbsp; =
YIPPEE!!!&nbsp;=20
...etc. etc. etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Now that it works, I can go on, and =
try to=20
me, it=20
would ruin all the fun I'll have when I have the "Duh!!"=20
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks, Jim Dixon</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A=20
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt; wrote in =
message <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest=20
value in a small group.&nbsp; The exact sample is =
below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL=20
style=3D"WIDTH: 159pt; mso-width-source: userset; mso-width-alt: =
7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: =
12.75pt; BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp;=20
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; =
BACKGROUND-COLOR: transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT=20
face=3DArial><FONT size=3D2><STRONG>2</STRONG>&nbsp;=20
2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT=20
face=3DArial><FONT size=3D2><STRONG>3</STRONG>&nbsp; 2.9610=20
</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT=20
face=3DArial><FONT size=3D2><STRONG>5</STRONG>&nbsp;=20
2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it =
to return=20
the lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take =
out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row =
<STRONG>4</STRONG> in it,=20
it returns a value of #N/A, I'm guessing from the HELP screen it's =
because=20
"...lookup_value is smaller than the smallest value in the first =
column of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone =
feels like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim=20
Dixon</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0009_01C7C84D.BE7E6560--

```
 0
jimd2081 (8)
7/17/2007 1:37:40 PM
```This is a multi-part message in MIME format.

------=_NextPart_000_0E2D_01C7C884.E2D90460
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I think that was clear from your post Jim, hardly warranted any extra =
comment.

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:eHcojdHyHHA.1576@TK2MSFTNGP03.phx.gbl...
I did know MIN would work, what I left out was I also wanted the value =
associated with the lowest cost, from column B, so I was using a VLOOKUP =
for both of them.  But thanks, nonetheless, I appreciate your and =
everyones help.
Jim

"T. Valko" <biffinpitt@comcast.net> wrote in message =
news:uaAFghAyHHA.1164@TK2MSFTNGP02.phx.gbl...
>when I have the "Duh!!" moment.

Like when you figure out that all you need is:

=3DMIN(A1:A5)

--=20
Biff
Microsoft Excel MVP

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl...
To Bob and Sandy, and anyone else who answers this =
question...MANY, MANY THANKS!!!  WHOOPEE!!!  YIPPEE!!!  ...etc. etc. =
etc.

Now that it works, I can go on, and try to answer my unwritten =
question...why?  No, don't answer it for me, it would ruin all the fun =
I'll have when I have the "Duh!!" moment.

Thanks, Jim Dixon
"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group. =
The exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm =
trying to get it to return the lowest cost, from column A.  If I take =
out Row 4, it works.  But with Row 4 in it, it returns a value of #N/A, =
I'm guessing from the HELP screen it's because "...lookup_value is =
smaller than the smallest value in the first column of table_array, =
VLOOKUP returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it =
thru his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0E2D_01C7C884.E2D90460
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I think that was clear from your post =
Jim, hardly=20
warranted any extra comment.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
href=3D"news:eHcojdHyHHA.1576@TK2MSFTNGP03.phx.gbl">news:eHcojdHyHHA.1576=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT face=3DArial size=3D2>I did know MIN would work, what I =
left out was I=20
also wanted the value associated with the lowest cost,&nbsp;from =
column B, so=20
I was using a VLOOKUP for both of them.&nbsp; But thanks, nonetheless, =
I=20
<DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"T. Valko" &lt;<A=20
=
href=3D"mailto:biffinpitt@comcast.net">biffinpitt@comcast.net</A>&gt; =
wrote in=20
message <A=20
=
href=3D"news:uaAFghAyHHA.1164@TK2MSFTNGP02.phx.gbl">news:uaAFghAyHHA.1164=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>&gt;when I have the "Duh!!"=20
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Like when you figure out that all =
you need=20
is:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3DMIN(A1:A5)</FONT></DIV>
<DIV><BR>-- <BR>Biff<BR>Microsoft Excel MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A=20
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt; wrote in =
message <A=20
=
href=3D"news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl">news:udWHfz9xHHA.748@T=
K2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>To Bob and Sandy, and anyone else =
this question...MANY, MANY THANKS!!!&nbsp; WHOOPEE!!!&nbsp;=20
YIPPEE!!!&nbsp; ...etc. etc. etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Now that it works, I can go on, =
and try to=20
me, it=20
would ruin all the fun I'll have when I have the "Duh!!"=20
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks, Jim Dixon</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A=20
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt; wrote in =
message <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to =
find lowest=20
value in a small group.&nbsp; The exact sample is =
below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL=20
style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: =
12.75pt; BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp;=20
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; =
BACKGROUND-COLOR: transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT =

face=3DArial><FONT size=3D2><STRONG>2</STRONG>&nbsp;=20
2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT =

face=3DArial><FONT size=3D2><STRONG>3</STRONG>&nbsp; =
2.9610=20
</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; =
2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT =

face=3DArial><FONT size=3D2><STRONG>5</STRONG>&nbsp;=20
2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it =
to return=20
the lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take =
out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row =
<STRONG>4</STRONG> in=20
it, it returns a value of #N/A, I'm guessing from the HELP =
screen it's=20
because "...lookup_value is smaller than the smallest value in =
the first=20
column of table_array, VLOOKUP returns the #N/A =
error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; =
Anyone feels=20
like helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim=20
=
Dixon</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></B=
ODY></HTML>

------=_NextPart_000_0E2D_01C7C884.E2D90460--

```
 0
bob.NGs1 (1661)
7/17/2007 2:12:27 PM
```This is a multi-part message in MIME format.

------=_NextPart_000_0064_01C7C878.EB375050
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Well then, guess I just had a Duh! moment!

--=20
Biff
Microsoft Excel MVP

"Bob Phillips" <bob.NGs@somewhere.com> wrote in message =
news:%23izhGyHyHHA.1212@TK2MSFTNGP05.phx.gbl...
I think that was clear from your post Jim, hardly warranted any extra =
comment.

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:eHcojdHyHHA.1576@TK2MSFTNGP03.phx.gbl...
I did know MIN would work, what I left out was I also wanted the =
value associated with the lowest cost, from column B, so I was using a =
VLOOKUP for both of them.  But thanks, nonetheless, I appreciate your =
and everyones help.
Jim

"T. Valko" <biffinpitt@comcast.net> wrote in message =
news:uaAFghAyHHA.1164@TK2MSFTNGP02.phx.gbl...
>when I have the "Duh!!" moment.

Like when you figure out that all you need is:

=3DMIN(A1:A5)

--=20
Biff
Microsoft Excel MVP

"Jim Dixon" <jimd@teoil.com> wrote in message =
news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl...
To Bob and Sandy, and anyone else who answers this =
question...MANY, MANY THANKS!!!  WHOOPEE!!!  YIPPEE!!!  ...etc. etc. =
etc.

Now that it works, I can go on, and try to answer my unwritten =
question...why?  No, don't answer it for me, it would ruin all the fun =
I'll have when I have the "Duh!!" moment.

Thanks, Jim Dixon
"Jim Dixon" <jimd@teoil.com> wrote in message =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small =
group.  The exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm =
trying to get it to return the lowest cost, from column A.  If I take =
out Row 4, it works.  But with Row 4 in it, it returns a value of #N/A, =
I'm guessing from the HELP screen it's because "...lookup_value is =
smaller than the smallest value in the first column of table_array, =
VLOOKUP returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get =
it thru his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0064_01C7C878.EB375050
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.3086" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Well then, guess I just had a Duh!=20
moment!</FONT></DIV>
<DIV><BR>-- <BR>Biff<BR>Microsoft Excel MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Bob Phillips" &lt;<A=20
href=3D"mailto:bob.NGs@somewhere.com">bob.NGs@somewhere.com</A>&gt; =
wrote in=20
message <A=20
=
href=3D"news:%23izhGyHyHHA.1212@TK2MSFTNGP05.phx.gbl">news:%23izhGyHyHHA.=
1212@TK2MSFTNGP05.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I think that was clear from your post =
Jim, hardly=20
warranted any extra comment.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
wrote in message <A=20
=
href=3D"news:eHcojdHyHHA.1576@TK2MSFTNGP03.phx.gbl">news:eHcojdHyHHA.1576=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT face=3DArial size=3D2>I did know MIN would work, what I =
left out was=20
I also wanted the value associated with the lowest cost,&nbsp;from =
column B,=20
so I was using a VLOOKUP for both of them.&nbsp; But thanks, =
nonetheless, I=20
<DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"T. Valko" &lt;<A=20
=
href=3D"mailto:biffinpitt@comcast.net">biffinpitt@comcast.net</A>&gt; =
wrote=20
in message <A=20
=
href=3D"news:uaAFghAyHHA.1164@TK2MSFTNGP02.phx.gbl">news:uaAFghAyHHA.1164=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>&gt;when I have the "Duh!!"=20
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Like when you figure out that all =
you need=20
is:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3DMIN(A1:A5)</FONT></DIV>
<DIV><BR>-- <BR>Biff<BR>Microsoft Excel MVP</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A=20
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt; wrote in =
message <A=20
=
href=3D"news:udWHfz9xHHA.748@TK2MSFTNGP04.phx.gbl">news:udWHfz9xHHA.748@T=
K2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>To Bob and Sandy, and anyone =
else who=20
answers this question...MANY, MANY THANKS!!!&nbsp; =
WHOOPEE!!!&nbsp;=20
YIPPEE!!!&nbsp; ...etc. etc. etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Now that it works, I can go on, =
and try to=20
for me, it=20
would ruin all the fun I'll have when I have the "Duh!!"=20
moment.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks, Jim Dixon</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A=20
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt; wrote in =
message=20
<A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to =
find lowest=20
value in a small group.&nbsp; The exact sample is =
below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
=
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL=20
style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: =
12.75pt; BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp;=20
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; =
BACKGROUND-COLOR: transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 =
x:num=3D"2.9441999999999999"><FONT=20
face=3DArial><FONT size=3D2><STRONG>2</STRONG>&nbsp;=20
2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial =
size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 =
x:num=3D"2.9609999999999999"><FONT=20
face=3DArial><FONT size=3D2><STRONG>3</STRONG>&nbsp; =
2.9610=20
</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; =
2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright height=3D17 =
x:num=3D"2.9630000000000001"><FONT=20
face=3DArial><FONT size=3D2><STRONG>5</STRONG>&nbsp;=20
2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; =
BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get =
it to=20
return the lowest cost, from column <STRONG>A</STRONG>.&nbsp; =
If I=20
take out Row <STRONG>4</STRONG>, it works.&nbsp; But with Row=20
<STRONG>4</STRONG> in it, it returns a value of #N/A, I'm =
guessing=20
from the HELP screen it's because "...lookup_value is smaller =
than the=20
smallest value in the first column of table_array, VLOOKUP =
returns the=20
#N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; =
Anyone feels=20
like helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim=20
=
Dixon</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></B=
LOCKQUOTE></BODY></HTML>

------=_NextPart_000_0064_01C7C878.EB375050--

```
 0
biffinpitt (3172)
7/17/2007 5:46:47 PM
```This is a multi-part message in MIME format.

------=_NextPart_000_0056_01C7C91A.277F5F20
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi Jim

VLOOKUP is a lookup and reference functions that works with value in =
ascending order. Please sort column A and thats all.

Good look
"Jim Dixon" <jimd@teoil.com> escribi=F3 en el mensaje =
news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl...
I'm trying to use VLOOKUP to find lowest value in a small group.  The =
exact sample is below:

A       B
1  3.0001    A=20
2  2.9442    B=20
3  2.9610     C=20
4  2.9055    D=20
5  2.9630    E=20

The formula I'm using is =3DVLOOKUP(MIN(A1:A5),A1:B5,1) .  I'm trying =
to get it to return the lowest cost, from column A.  If I take out Row =
4, it works.  But with Row 4 in it, it returns a value of #N/A, I'm =
guessing from the HELP screen it's because "...lookup_value is smaller =
than the smallest value in the first column of table_array, VLOOKUP =
returns the #N/A error..."

Sorry, don't get it.  Anyone feels like helping a noobie get it thru =
his skull?

Thanks,
Jim Dixon
------=_NextPart_000_0056_01C7C91A.277F5F20
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1593" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Hi Jim</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>VLOOKUP is a lookup and reference =
functions that=20
works with value in ascending order. Please sort column A and thats=20
all.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Good look</FONT></DIV></DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jim Dixon" &lt;<A =
href=3D"mailto:jimd@teoil.com">jimd@teoil.com</A>&gt;=20
escribi=F3 en el mensaje <A=20
=
href=3D"news:OPKjce9xHHA.3564@TK2MSFTNGP06.phx.gbl">news:OPKjce9xHHA.3564=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to use VLOOKUP to find =
lowest value in=20
a small group.&nbsp; The exact sample is below:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<STRONG>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
B</STRONG></FONT></FONT></DIV>
<DIV>
<TABLE style=3D"WIDTH: 207pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
<COLGROUP><FONT face=3DArial>
<COL style=3D"WIDTH: 48pt" width=3D64>
<COL style=3D"WIDTH: 159pt; mso-width-source: userset; =
mso-width-alt: 7753"=20
width=3D212><FONT size=3D2></FONT></FONT>
<TBODY>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
align=3Dright width=3D64 height=3D17 =
x:num=3D"3.0001000000000002"><FONT=20
face=3DArial><FONT size=3D2><STRONG>1</STRONG>&nbsp; =
3.0001</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 159pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
width=3D212><FONT face=3DArial size=3D2>&nbsp;&nbsp; =
A</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9441999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>2</STRONG>&nbsp; 2.9442</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;B</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9609999999999999"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>3</STRONG>&nbsp; 2.9610 </FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; C</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9055"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>4</STRONG>&nbsp; 2.9055</FONT></FONT></TD>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
face=3DArial size=3D2>&nbsp;&nbsp; D</FONT></TD></TR>
<TR style=3D"HEIGHT: 12.75pt" height=3D17>
<TD class=3Dxl24=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
align=3Dright height=3D17 x:num=3D"2.9630000000000001"><FONT =
face=3DArial><FONT=20
size=3D2><STRONG>5</STRONG>&nbsp; 2.9630</FONT></FONT></TD>
<TD=20
style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;=20
E</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The formula I'm using is=20
=3DVLOOKUP(MIN(A1:A5),A1:B5,1)&nbsp;.&nbsp; I'm trying to get it to =
return the=20
lowest cost, from column <STRONG>A</STRONG>.&nbsp; If I take out Row=20
<STRONG>4</STRONG>, it works.&nbsp; But with Row <STRONG>4</STRONG> in =
it, it=20
returns a value of #N/A, I'm guessing from the HELP screen it's =
because=20
"...lookup_value is smaller than the smallest value in the first =
column of=20
table_array, VLOOKUP returns the #N/A error..."</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sorry, don't get it.&nbsp; Anyone =
feels like=20
helping a noobie get it thru his skull?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jim =
Dixon</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0056_01C7C91A.277F5F20--

```
 0
7/18/2007 3:00:45 PM

Similar Artilces:

Re: Using Outlook Object Model from an NT Service
Due to a business need, I need to use the Outlook Object Model spawne from an NT Service to update users' Outlook calendar. That's don through setting up the user's calendar delegate. However that i occationally crashing/not working without a clue (at least for now.) Application log files or Event Viewer is not showing an errors/warnings. Does any one know if CDO can set the calenda delegate? Without using the Exchange admin credentials, is ther anyway to access another user's calendar and not other folders lik Inbox? Thanks for any help in advance - oracio ------------...

Problem with vlookup
Hi, Column A1:A10 has the numbers 10-1 and B1:B10 has price of a stock. Problem when I lookup the number = 12, it returns always the value in cell A10. Vlookup(12, A1:B10,2)=Value in cell B10, But A10 = 1, and this is not close, I want the closest number which would be 10, the value in cell A1. Is there any way to do this? Thanks for your help type =vlookup(12,a1:B10,2,false) it will give #N/A becaue there is no number as 12 in column A. Jeff <Jeff@discussions.microsoft.com> wrote in message news:FE1D3FBA-1BC1-47E9-8AE4-5C7015282E52@microsoft.com... > Hi, > > Colum...

Exchange doesn't send mail to some domain that use to delivery mes
Hi, we have a windows small business server 2003 Premium with Exchange. The server that get messages in mail server (in the provider) and all mail that we send the server redirect to smtp in provider. But now we have a problem. All work finelly but the smtp is mail.provider.com and the clients of the provider have a mail likely abc@mail.provider.com and when we send mail to abc@mail.provider.com the mail never is received, but we don't receive any error. I think that exchange server enter in loop when receive a message with the same name of the smtp used to send mail. Any ideia? Anybody...

interactive picture using behaviors
I want to add an interactive feature to my website which allows people to click to make an animated candle appear and then stay there, even if clicked again. I also would like them to be able to add a name below or beside the animated candle, but I have a feeling that the addition of a name would be asking too much from FP 2003. Any help would be much appreciated (but please, keep it simple). Thanks! Producing the candle is fairly easy - see http://www.rxs-enterprises.org/tests/show-and-hide.aspx for an example. To use a name requires a form and form processing with javascri...

Anyone use MrExcel.com? Just a comment...
Hello all, I'm in and out of this newsgroup from time to time, but occasionally I visit the MrExcel message board. I've been a member for about two years now, and at least 95% of my posts are in response to someone who needs help. Maybe 2 or 3 times I've actually had to ask something, and I've been using Excel since the mid 90's or so (about when it first came out I think). If I HAVE to ask a question, it's generally pretty intense as there aren't that many things I cannot figure out on my own or with the Help files. So, a couple of weeks ago I ran across a po...

Use of Folder List
Somebody HELP me! I have many folders at folder list section. and use of mail rules, mails go to a specific folder for sorting. Problem is that unless all of the folders are seen on the folder list section, I cannot tell if I received a mail or not. How can I make it that when a mail comes in to a sub-sub-folder, main folder will become bold letters to tell me that it is unread mail is in somewhere in the folder family? Please let me know. I am using xp outlook. My Mac Enourage does it fine. Thank you!!! ...

VLookUp Question #11
I have the vlookup formula below in b2. My table names are in row1 (Jan,Feb). Is it possible to have the lookup formula refer to cell b1 for the name of the table. Jan Feb QQQQ =VLOOKUP(A2;B1;4;FALSE) Thank you in advance. Try: =VLOOKUP(A2,INDIRECT(B1),4,0) HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6261 View this thread: http://www.excelforum.com/showthread.php?threadid=496700 ...

moving to next cell using "Enter"
With Excel XP (Windows EX also) Excel seems to have a problem remembering what direction to move the focus when the Enter key is hit. Is there a fix or a way of keeping it the same? Thanks -- Joseph Meehan Dia duit Hi, Go to Tools->Options and choose Edit tab. In that choose the direction of the Enter key to the way you want. Govind. Joseph Meehan wrote: > With Excel XP (Windows EX also) Excel seems to have a problem > remembering what direction to move the focus when the Enter key is hit. Is > there a fix or a way of keeping it the same? > >...

Vlookup Differentation Risks
I'm using a vlookup function to draw data from a source sheet, into a matrix report. We want to be able to review each service provider's data. If 2 different / unrelated service providers share the same reference numbers, how can the vlookup function accuratley differentiate between each provider's data? How can this function be adjusted to capture data that is specifically cooresponds to the right service provider? Addie -- addie ------------------------------------------------------------------------ addie's Profile: http://www.excelforum.com/member.php?action=getinfo&...

MSExchangeDSAccess
Hi, My customer had this error on his Win 2003 SMB server yesterday: MSExchangeDSAccess MAD.EXE (PID=4448). All Domain Controller Servers in use are not responding : <his.domain>.local System info: Acer G320 SMB server, P4 3GHz, 1 GB RAM, 80 GB in RAID1 (mirror) CA (Computer Associates) security suite installed - SCM R8 (eTrust Secure Content Management) - ITM R8 (Integrated Thread Management) 6 client PC's (3 wireless) Q1: What will the customer / employees notice as consequences ? Q2: Is this critical ? Q3: Will this automatically be resolved by some recovery /...

using IM for RM with Commissions and Analysis codes
Hello there, We've got an integration which derives from the example RM with Commisions that ships with IM. We've tried a number of things, and just cant get the analysis codes to populate in GP. In one case, we included them in the Distributions source file. In another case we created a separate source that was tied to the Distribution through a composite key. Neither of these methods has yielded success. Anyone have any experience with this and might be able to help us get on the fast track with this? Thanks. David Buttrick ...

Use the propertyInfo to setValues
Hello. I am using the propertyInfo type. dim pi as propertyInfo pi = myClass.getType().getProperty("myPropertyName", BindingFlags.Public Or BindingFlags.Instance) myPropertyName may be any property, such as borderLevel, etc. I want to set myPropertyName to a specific value, as propertyGrid does (I mean - by sending it a string). I see there are methods : getGetMethod, and getSetMethod - Are those method the property editors ? Can I use those method to solve the problem ? How can I do that ? Thanks :) On 21/06/2010 13:45, Mr. X. wrote: > I am using...

HELP menu shouldhave a choice of USE WIZARD, use STANDARD
XP PROsp2 OFFICE 2003Pro when using the help feature it should be already customized to the feature of OUTLOOK that is being used when you try to use help, when using the calendar, the help menu should be about CALANDAR, and i suggest that all help menus have a choice of wizards...described below. When you use the help feature, the drop down menu should be a choice of wizards to use: HOME PC standalone HOME PC with networking OFFICE PC standalone workstation etc etc..... Once the user selects the wizard, all selections should be about information that pertains to: the feature being u...

Can't usefully record macro
Word 2003 I attempted to record a macro then reposition a table by grabbing the little table reposition icon but it won't let me do it. I just want to record moving a table and then view the recorded maco. (I have Word 2007 at home and I've never had this problem) In record mode it only lets me type in stuff. Try recording the action of positioning the table using the Table Properties dialog. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted...

create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10)
I've written a formula that produces rations (e.g., 1:250) by concatenting "1:"&(a6*w34). How can I persuade Excel to draw charts of the results? It wants to interpret them all as "1" Thanks for you help. A concatenated cell contains a string. XL can only plot that on a Category axis (x-axis for charts such as Line, Column, Area). It cannot use a string for a y-value. What you may want to do is plot the decimal equivalent and then use the ratio column as a label for the plotted series. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, ...

Using Sumproduct and Dates
I am currently working on a workbook that has various part nmbers (2060207-WPI001) on work sheet 7-14-07 in E:E in which I match a 1 to 3 letter designations as in "WPI". In column AI:AI is the dates which these pieces are scheduled to cast. I need to place a date in cell H3 of sheet 1 as 8/30/07 and sum the total occurences which are less than or equal to the 8/30/07 date. When I use the following I return the total occurences were WPI is listed but I need the sum of those with dates less than or equal to 8/30/07 for billing purposes. =SUMPRODUCT(--(ISNUMBER(FIND({"WPI"}...

Problem using CPropertySheet over CFormView
Hi! I have three views in an MFC SDI application, split using CSplitterWnd. And in one of the views we have some edit controls and gird controls. In the same view, on selection of a menuitem, I create a modeless CPropertySheet with two pages and place it over the edit controls. Now on clicking the property sheet, I am getting the overlapped display of editcontrols in the view. How can I avoid this. Please help. Thanking you in anticipation. Best Regards! Babu PSM Babu wrote: > Hi! > > I have three views in an MFC SDI application, split using > CSplitterWnd. > And in one ...

using linear / non linear graphs to extract results
Hi, A frequent function of my job is to analyse data on graphs/charts to extract data for engineering data , i.e power / temperature/flowrates etc etc Is the a microsoft based programe i.e. Excel/Access that is capable of understanding data on a scaled X-Y axis that if an X value was entered in a cell, the programme would extract a corresponding Y value from a line on a graph ? If anyone has any woring examples of such a thing, I'd appreciate a link Thx Hi, If there is a linear relationship between X and Y use the function FORECAST It a power series is needed use LINEST - see examp...

Using Templates
I am creating a newsletter, and I want to use different templates for different pages within the same newsletter. How do I do this? When I try, it applies the same template to all of the pages within the newsletter. You'll have to do some copy/paste operations for two different templates to work. Make a note of the color scheme before you paste, usually the color scheme does not come along when you paste. It will be the same for the post you made about the ad. Group all the objects in the ad, copy/paste. -- Mary Sauer http://msauer.mvps.org/ "Samantha Jayne" <Samant...

Can I use winusb.sys to install an HID device instead of hidclass.
I am trying to use install a custom manufactured HID device on Windows 7 64-bit using winusb.sys. The device installs perfectly using the windows supported HID driver (hidclass.sys). However, I want to install the device using winusb.sys. I've created the driver package (including inf file, coinstallers for 32 and 64-bit OS's, unsigned setup catalog file using inf2cat). The two main errors in setupapi.log are: "Verifying file against specific (valid) catalog failed! (0x00000057) Error 87: The parameter is incorrect. {_VERIFY_FILE_SIGNATURE exit(0x00000057)}"...

Organizing my freq used formulas/expressions
Hi Everyone, I use excel 2000 and 2003. I am working on learning to use excel to filter out data etc. Anybody have a method to organize the formulas/functions/expressions that one frequently uses? Since I am just getting started with this stuff I can't really come up with the formulas on my own yet so I need the "template" for future use....For example. The 2 expressions below did the same thing on my excel sheet and I will no doubt use them again for another project. =TEXT(B3,"mm/dd/yyyy")=TEXT(D3,"mm/dd/yyyy") =int(c3)=int(d3) (=int() will take ...

Yahoo mail POP connect error using Outlook Express 6. It was working all right before.
I have a free yahoo account "..accountname@yahoo.ca". It was working alright for years, but since a few days ago, I have the following problem: The server responded with an error. Account: 'mwintrust@yahoo.ca', Server: 'pop.mail.yahoo.com', Protocol: POP3, Server Response: '-ERR Cannot connect to POP server 216.136.173.10 (216.136.173.10:110), connect error 10061', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC90 Thanks for anyone's help. did yahoo.ca end pop support for free accounts? -- Diane Poremsky [MVP - Outlook] A...

Formatting the result of a VLookup / Custom Formatting #3
Hi, I am having difficulty formatting a cell which contains both text and a VLOOKUP formulae. I have an example of the cell below: ="Here lies the text before Vlookup " &VLOOKUP(\$M\$20,sheet1!\$B\$10:\$L\$1445,8,FALSE)&" Here lies follow-up text" The VLookup should return a date but instead is returning a string of numbers. I'm sure there is a way of setting the format within the formulae using dd/mm/yy somewhere. Could anyone tell me how to do this? ...

Create an XLIFF editor using C# and .Net 3.5 technologies.
can any one please tell me how to do this one even any example or links to do will be appreciated Create an XLIFF editor using C# and .Net 3.5 technologies. Requirements: The tool should be able to perform the following: * Open an existing XLIFF file * Save the modified XLIFF file * Display the Id (read only) * Display the un-translated text (read only) * Display and edit the translated text (read/write) o Changing the text should automatically change the state to translated * Display and edit the translation state as a Boolean (is translate...

XPathNavigator not working when schema used
PLEASE HELP! I'm writing a function to populate DropDownLists from and xml file. I am having a problem getting my XPathNavigator to select any nodes when I attach a schema to my xml document. Xml Doc: Dropdown.xml XML Schema: Dropdown.xsd Here is my XML Document... <?xml version="1.0" encoding="utf-8" ?> <DropDownLists xmlns="http://tempuri.org/DropDown.xsd"> <DropDownList name="DataSource"> <Option name="SqlServer" value="SqlServer" /> <Option name="Oracle" value="Oracle" /&...