#### 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
915 Views

Similar Articles

[PageSpeed] 19

```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:

na() and #na label displayed on graphs...
Hi all, I have got a list of data and some are resulting from the NA() function. Objective is to avoid a 0 value plot on the graph..... and it is working great. BUT On the graph, I set the label of each ploy to "value". And unfortunately a #NA label is displayed on the graph on each plot where there is the NA()... How can I remove the #NA from my graph ? Thks, AL. In a column or bar chart, you may as well use "". NA() is what works only for marker series (line, XY, and some radar series) by completely hiding the point. In column and bars, the point is plotted, but h...

What category to use for a reimbursed personal Job expense
Hi there! In MS money plus home and business edition, what category do i use for a Job expense that was reimbursed to me. MSMoney has the Category, as expense, of: Job Expense, and under that with subcategories of: 1-Non-reimbursed 2-Reimbursed However, there is no associated income for this. So once i get the reimbursed payment from my company, what do i do? Which category, under income should i use. Also, the "Reimbursable" tick box is always grayed out. What am i missing here? Appreciate a lot any help, =Dee You could create an Income category. Other Income : Job ...

Using filtered form data as record source for report
I have a split form in an Access 2007 database where the data grid shows the records from a query. The user can filter any combination of fields from the the drop down headers. I have a command button above the data grid that opens a report with the same query as its record source. I'm trying to figure out how to pass the filtered data to the report so it will show only those records that the user is seeing in the data grid of the split form. Any help with this issue will be greatly appreciated. Ken You may be able to pass the Filter of your form as the WhereCondition ...

Search using exact criteria for customers
In Point of Sale there should be an option for an 'exact search', so that results that do not match any existing records do not return a result that is similar to what was searched on. Currently users will enter an incorrect or non-existent customer number and will accidentally select the wrong customer instead of receiving an "Invalid number" message. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do n...

Use Delete But mailbox not delete
Hi All, How to delete mailbox in exchange 5.5 NT 4.0 after deleting the user in W2k. If you are not running an ADC or do not it configured to delete objects on the 5.5 side, you need to use the Exchange Admin tool and NT 4.0 user manager. -- regards, Michael Abbaticchio MVP for Exchange Server http://mvps.org/exchange "cosy" <anonymous@discussions.microsoft.com> wrote in message news:109b001c3f41a\$f7c78140\$a001280a@phx.gbl... > Hi All, > > How to delete mailbox in exchange 5.5 NT 4.0 after > deleting the user in W2k. ...

#NA
Hi Is there a way to check that if a vlookup command returns a NA then it puts in a 0 not a NA? I have a list where I run vlookups but if the reference does not exist in the lookup table it returns a NA. I realise that I can run a ISNA and check but I was hoping to have something similar to =if(=vlookup(lookup,table,column,false)=NA,0,=vlookup(......)) Thanks Carlob1 Hi use =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) -- Regards Frank Kabel Frankfurt, Germany "Carlo" <carlob@global.co.za> schrieb im Newsbeitrag news:bfbc8513.0408150315.638088a3@posting.google.com... > Hi >...

How do I export a to a text file not using TransferText
I am trying to export data from a form to a text file, but I must sort the fields before exporting them, as in the first field to be the first line and the second field to be start on the next line on the text file and with TransferText I can not accomplish that. please help me with the coding of exporting the data. Thanks a million. This snippet shows how to open a file and write stuff to it: Dim FileSpec As String Dim lngFN As Long Dim strLine As String FileSpec = "D:\Folder\File.txt" lngFN = FreeFile() Open FileSpec For Output As #lngFN strLine = "Conte...

How to select Chart without using Mouse?
Hi.... Is there any option on how to select the chart without using mouse button. Ex.: I have created the bar chart using mouse and clicked on the empty cell.... now tell me how to select that chart without using mouse. Need response at the earliest. Regards On Mon, 30 Jul 2007, in microsoft.public.excel.charting, Rajkumar <Rajkumar@discussions.microsoft.com> said: >Is there any option on how to select the chart without using mouse button. Alt-E Edit menu G Go To.. Alt-S Special Alt-b Objects Enter Tab until you get to the chart object you want Context menu ke...

MSPOS: When I print a label with a barcode, the barcode uses the e
MSPOS: When I print a label with a barcode, the barcode uses the entire field length Course then the bar code reader can't scan it. It appears that the program is attempting to always use the entire width of the field instead of printing within the field size like RMS does. 5 numbers in ILC, any barcode type, barcode label field size 1.5" wide, always prints the barcode 1.5" wide Use a Dymo 330 Turbo printer, Windows driver using the same label format/info and field sizes that works fine in RMS and all other programs Sure glad I'm not selling this!! 4 bugs/_feat...

Using combo boxes
I am trying to use a combo box control to access a list of data. i am having problems 'pointing' the combo box to the list of data I would like to use. Where do I tell the box where to look ??? thanks PS I cannot use the 'forms' combo box as this has does not allow me to type in the combo box. Look at the Listfillrange property. On Thu, 28 Aug 2003 "Disco" <stuart_langan@yahoo.co.uk> wrote: >I am trying to use a combo box control to access a list of >data. >i am having problems 'pointing' the combo box to the list >of data I would l...

Use of BizTalk2004
We are in the process of evaluating whether to use MS-CRM. However, all of the published documentation indicates that the workflow is based on BizTalk2002. The question here is can I run BizTalk2004 as the integration platform between our other BizTalk2004 applications and orchestrations along with CRM 1.2? Thanks for your perserverence. Hi Hans. MS-CRM does not use BizTalk for workflow. -- Eric Hood Developlus Services, Inc. http://www.developlus.net "Hans" <Hans@discussions.microsoft.com> wrote in message news:CDF67422-4FC1-4161-B34F-DE1489C1489D@microsoft.com... ...

Can excel be used to calculate areas under curves? Like integrat.
Can anyone tell me how to calculate areas under curves using excel? Thanks, Hi see: http://www.stfx.ca/people/bliengme/ExcelTips/ -- Regards Frank Kabel Frankfurt, Germany "Rob" <Rob@discussions.microsoft.com> schrieb im Newsbeitrag news:11688BAF-FA2F-4457-9B29-F1FE9B26C626@microsoft.com... > Can anyone tell me how to calculate areas under curves using excel? > Thanks, ...

Closed accounts not used in budget
I closed a couple of accounts this year and I am finding out that after marking them as "closed" in the accounts list, the transactions are not considered anymore in budget. If I go into each category or into each payee, the payments I made from the now closed accounts are still there but not in budget. These accounts are selected in the "accounts to use in budget" and if I reopen them, budget uses them, but not if they are closed. Reopening and reclosing the accounts every time I use budget and account list is not very practical. Is everybody experiencing this issue ...

Data tables and VLOOKUP
Hi, I have a master list of raw stock returns where rows are individual companies and columns are months (as in jan 73, feb 7, mar 73...). I need to extract out at the start of each month, according to a certain criteria, the monthly returns (on the master list) for the next few years. So, I created separate worksheets at the start of each month and used the VLOOKUP function to extract the returns (from the master list) for the first month. And then used the data table function to find the monthly returns for the next few years. My problem is: In my master list, some companies are '...

Compact OE
Several people I know who do not use Outlook Express keep getting messages when they boot their computer to Compact Outlook Express messages. They don't do it, not knowing what the message is for or about. How can they stop this message from appearing since they don't useOE? Mich After XP SP3 install repeated prompts to compact Outlook Express (OE). Starting with XP SP2, you get the prompt to compact after 100 closings of OE and every one thereafter until you compact. SP3 changes the way the compact count gets incremented. With SP2, only closing the main program...

Using the "Go To" dialog for "Copy"
Is there a way to bring up a dialog similar to the F5 "GoTo" dialog (which lists named ranges), and, instead of "going there," copying the data in the selected (from the list) range to the clipboard? I guess I could create a macro that brings up a userform to do it, but I'm looking for an existing solution: Bring up a list of named ranges, select a range (from the list, not selection of cells in the worksheet), and press OK to copy the contents of that range to the clipboard. The current active cell is my paste destination. If I have to select the source cells I will...

Rules using "NOT"
I would like to apply an Outlook rule to all mails from outside my organisation. The only way I can see to do this is to set up a rule condition that applies to all mails where the sender's address does NOT contain the string "mydomain". Unfortunately, I cannot seem to find a way to do this, although the reverse is simple. Is there a way to do this, or is there another potential solution? The environment is Outlook 2007 / Exchange 2007 - Exchange Account. Thanks in advance for any assistance, Alex. Alex wrote: > I would like to apply an Outlook rule to...

How to Use/Replace Capicom in VBS script on Windows7 x64?
We have a project that call Capicom.dll in a VBS script to fetch/add/delete certs from both local computer and Active Directory stores, as following: -------------------------------------------------------------------------------- Set store = CreateObject("Capicom.Store") store.Open 2,"MY",130 If Err.Number > 0 Then log "Error:Vbscript error found:" & Err.Number &" " & Err.Description --Line *** Else log "Error:CAPICOM error found : " & Err.Number &&q...

Why must the table for Vlookup be sorted in ascending order?
Is it true that under all circumstances I must sort the array table in **ascending** order so that VLOOKUP will return the proper values? Is it only necessary when I deal with ranges, say minimum score and a grade? Appreciate explanation. I have a column of scores and a corresponding column of grades. e.g. 90 A 80 B 70 C 60 D I am surprised that if the table is in **descending** order and ��true�� is used as an argument, it doesn��t work even if I key in the **exact** score say 90, not 95, not 93. "D" is returned for 90. Wonder why. Thank you in advance. Epinn &quo...

How can I use VBA to insert a char at the current text insertion point?
Imagine you are designing a form where the user might have to enter the name of someone from Slovenia called Tomaz Crnej where you wish, out of courtesy, to spell his name correctly. Both the lower case 'z' and the upper case 'C' should therefore have a breve accent above the character. You can enter a z with a breve by typing Alt-0158 in the Tahoma font (for example). However, no such keyboard shortcut exists for a capital C with a breve. For this reason, I wish to design a much simplified version of Windows Character Map within my Access 2003 application. However, I d...

using AND in a countif formula
I am trying to make a formula that gives me a count of how many row have the same date and time...i have tried everything i can think o and can't seem to get it...any help is appreciated! i.e. saturday 14:00 saturday 11:00 saturday 14:00 saturday 14:00 saturday 14:00 monday 14:00 monday 14:00 tuesday 4:00 tuesday 14:00 tuesday 1:00 there will be 7 fields...one for each day and time...so in the abov example they should display:(i left a lot of fields out below...onl mentioned the ones that are used in the example) saturday/14:00 - 4 saturday/11:00...

Bank Balance NA in Essentials