lookup formulas

I have a lookup formula working just fine as long as what
I want it to look up is there. My problem is that when
the number I want it to look for is not on the spreadsheet
it is still coming up with a number. Any ideas on why
this would be?
=LOOKUP($B$2,'J:\atp2003\10105079
GM\creports\[hourlyteampdb0911.xls]530 combo report'!
$E$2:$E$73,'J:\atp2003\10105079
GM\creports\[hourlyteampdb0911.xls]530 combo report'!
$K$2:$K$73)
As you can see here, I'm wanting it to find in column E of
my combo report the number that is in cell B2 of my
spreadsheet and give the corresponding number in column K
of my combo report. It's working except for the fact that
this number does not exist on this particular worksheet,
therefore it should be giving me an error, NA or nothing,
instead it is coming up with the number 4.

Add the "FALSE" option at the end of your VLOOKUP formula.....

=vlookup(B2,range,offset,FALSE)

Vaya con Dios,
Chuck, CABGx3


"Marian" wrote in message
...
I have a lookup formula working just fine as long as what
I want it to look up is there. My problem is that when
the number I want it to look for is not on the spreadsheet
it is still coming up with a number. Any ideas on why
this would be?
=LOOKUP($B$2,'J:\atp2003\10105079
GM\creports\[hourlyteampdb0911.xls]530 combo report'!
$E$2:$E$73,'J:\atp2003\10105079
GM\creports\[hourlyteampdb0911.xls]530 combo report'!
$K$2:$K$73)
As you can see here, I'm wanting it to find in column E of
my combo report the number that is in cell B2 of my
spreadsheet and give the corresponding number in column K
of my combo report. It's working except for the fact that
this number does not exist on this particular worksheet,
therefore it should be giving me an error, NA or nothing,
instead it is coming up with the number 4.

You need to add 'FALSE' after the last number. ie =VLOOKUP
(A1,B110,2,FALSE)

This will return an error message. Hope this is what you
need

Barb

-----Original Message-----
I have a lookup formula working just fine as long as what
I want it to look up is there. My problem is that when
the number I want it to look for is not on the
spreadsheet
it is still coming up with a number. Any ideas on why
this would be?
=LOOKUP($B$2,'J:\atp2003\10105079
GM\creports\[hourlyteampdb0911.xls]530 combo report'!
$E$2:$E$73,'J:\atp2003\10105079
GM\creports\[hourlyteampdb0911.xls]530 combo report'!
$K$2:$K$73)
As you can see here, I'm wanting it to find in column E
of
my combo report the number that is in cell B2 of my
spreadsheet and give the corresponding number in column K
of my combo report. It's working except for the fact
that
this number does not exist on this particular worksheet,
therefore it should be giving me an error, NA or nothing,
instead it is coming up with the number 4.
.