software

I have a Lookup command and it's working for everything but the last entry in
the source list
=LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
Entries in rows A14:A36 are found successfully, but A37 returns a blank even
though there is data in B37
Rows 38 and 39 are currently blank

Could you clarify...
What cell is this formula in, and how are you changing it to look up
different entries in the source list? If you're doing that by autofilling
the formula below (or copying and pasting it into additional rows), I suspect
the problem is that the relative references are causing the table reference
to advance off the table. Enter the formula using absolute references for
the table: =LOOKUP(A8,WKFLDS!$A$14:$A$39,WKFLDS!$B$14:$B$39)
--Bruce

quot;tracyquot; wrote:

gt; I have a Lookup command and it's working for everything but the last entry in
gt; the source list
gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; though there is data in B37
gt; Rows 38 and 39 are currently blank

You need to quot;anchorquot; your lookup range else as you copy the formula down, the
lookup range moves (and you could experience what you are experiencing.)

Use absolute references for those ranges (by preceeding the cell/column with
$. For your formula, try:

=LOOKUP(A8,WKFLDS!$A$14:$A$39,WKFLDS!$B$14:$B$39)

--
Kevin Vaughnquot;tracyquot; wrote:

gt; I have a Lookup command and it's working for everything but the last entry in
gt; the source list
gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; though there is data in B37
gt; Rows 38 and 39 are currently blank

My range is correct.
I was testing out the formula for all values between A14 and A39 and the
only one that doesn't work is A37
I changed the formula to anchor the range and it still is a problem

quot;tracyquot; wrote:

gt; I have a Lookup command and it's working for everything but the last entry in
gt; the source list
gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; though there is data in B37
gt; Rows 38 and 39 are currently blank

Important The values in array must be placed in ascending order: ...,-2, -1,
0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct
value. Uppercase and lowercase text are equivalent
--
paul
remove nospam for email addy!
quot;tracyquot; wrote:

gt; I have a Lookup command and it's working for everything but the last entry in
gt; the source list
gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; though there is data in B37
gt; Rows 38 and 39 are currently blank

The values are in ascending order.
project a
project b
....
project x is the last in the list and it's the one that doesn't return a
value. It returns blanks not #N/Aquot;paulquot; wrote:

gt; Important The values in array must be placed in ascending order: ...,-2, -1,
gt; 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct
gt; value. Uppercase and lowercase text are equivalent
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;tracyquot; wrote:
gt;
gt; gt; I have a Lookup command and it's working for everything but the last entry in
gt; gt; the source list
gt; gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; gt; though there is data in B37
gt; gt; Rows 38 and 39 are currently blank

Never mind...I switched to VLOOKUP and got it to work....
Thanks for your help.

quot;tracyquot; wrote:

gt; I have a Lookup command and it's working for everything but the last entry in
gt; the source list
gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; though there is data in B37
gt; Rows 38 and 39 are currently blank

Based on everything you said, and based on some testing I did, I would ask if
you copy/pasted the formula when posting your message or typed it in. If
your formula were slightly different, I could see you getting the results you
stated:

=LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B15:B39)

If that isn't it, I don't know what it is.
--
Kevin Vaughnquot;tracyquot; wrote:

gt; The values are in ascending order.
gt; project a
gt; project b
gt; ...
gt; project x is the last in the list and it's the one that doesn't return a
gt; value. It returns blanks not #N/A
gt;
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; Important The values in array must be placed in ascending order: ...,-2, -1,
gt; gt; 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct
gt; gt; value. Uppercase and lowercase text are equivalent
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;tracyquot; wrote:
gt; gt;
gt; gt; gt; I have a Lookup command and it's working for everything but the last entry in
gt; gt; gt; the source list
gt; gt; gt; =LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
gt; gt; gt; Entries in rows A14:A36 are found successfully, but A37 returns a blank even
gt; gt; gt; though there is data in B37
gt; gt; gt; Rows 38 and 39 are currently blank


this is a test--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=511235