VLOOKUP
 

hard to tell from your info, but a few questions/suggestions/observations
for you:
1) how do you know it stops at row 30?
2) fyi: cell D18 is looking in columnJ for exactly what is in cell B10, then
going over to columnL and returning that value, if any; while cell B18 is
looking in columnJ for exactly what is in cell B10, then going over to
columnK and returning that value, if any. You indicated you were pulling
info from columns J & L, not L & K as code states.
3) try naming the range on sheet1!J2:L34 and referring to that range in your
vlookup. highlight sheet1 range J2:L34, hit 'insert' 'name' 'define' and
type in 'mylookuprange'. then change formula to
=vlookup(b10,mylookuprange,2,false).
4) lastly, make sure you are on automatic calculate (tools, options,
calculation, automatic) or hit F9 to manually calculate potentially
un-updated results from a changed formula (30--34).
hope this helps, mike allen

"Gfunc" wrote in message
...
Hiya,
what should be a relatively simple problem is driving me craaaazy. I have
a spreadsheet with 2 cells on vlookup:
(Cell d18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,3,FALSE)) AND
(cell B18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,2,FALSE))

My problem is that it is only looking up to row 30... not all the way to
row 34...

to claritfy:

B10 is a drop down box where I choose which category i want.
once I click the category, it auto inputs data pulled from the data in
coulms j & L.
It is supposed to pull all the way down to the 34th row, but for some
reason, it stops at row 30... It originally was programmed to only go to row
30, but as you can see from the formula, I have adjusted for the addition.

Any help is greatly appreciated.

Gfunc

VLOOKUP
 

Mike, thanks for the response.
1) I know it stops at row 30 because there are 4 itmes that are not displayed in the drop down window. the last item i can select happens to be in row 30. the last piece of data is actually in row 34...

2) thanks for the FYI, you are correct, it is actually pulling from row k

3) I did try this, it is still not working properly.

4) same here, it is on automatic.

Would it be possible to email it? thanks for the help.

"mike allen" wrote:

hard to tell from your info, but a few questions/suggestions/observations
for you:
1) how do you know it stops at row 30?
2) fyi: cell D18 is looking in columnJ for exactly what is in cell B10, then
going over to columnL and returning that value, if any; while cell B18 is
looking in columnJ for exactly what is in cell B10, then going over to
columnK and returning that value, if any. You indicated you were pulling
info from columns J & L, not L & K as code states.
3) try naming the range on sheet1!J2:L34 and referring to that range in your
vlookup. highlight sheet1 range J2:L34, hit 'insert' 'name' 'define' and
type in 'mylookuprange'. then change formula to
=vlookup(b10,mylookuprange,2,false).
4) lastly, make sure you are on automatic calculate (tools, options,
calculation, automatic) or hit F9 to manually calculate potentially
un-updated results from a changed formula (30--34).
hope this helps, mike allen

"Gfunc" wrote in message
...
Hiya,
what should be a relatively simple problem is driving me craaaazy. I have
a spreadsheet with 2 cells on vlookup:
(Cell d18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,3,FALSE)) AND
(cell B18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,2,FALSE))

My problem is that it is only looking up to row 30... not all the way to
row 34...

to claritfy:

B10 is a drop down box where I choose which category i want.
once I click the category, it auto inputs data pulled from the data in
coulms j & L.
It is supposed to pull all the way down to the 34th row, but for some
reason, it stops at row 30... It originally was programmed to only go to row
30, but as you can see from the formula, I have adjusted for the addition.

Any help is greatly appreciated.

Gfunc

VLOOKUP
 

I didn't realize "it" referred to the dropdown box only going to 30. I
thought you were saying the vlookup formulas were not looking past 30. I
would say re-establish your 'data' 'validation' 'allow' 'list' by making
sure 'source' is now referring down to row 34. If 'source' is for sure
including line 34, make sure you are scrolling all the way down your
dropdown box. that's all i can think of. let me know how it goes, mike
allen
"Gfunc" wrote in message
...
Mike, thanks for the response.
1) I know it stops at row 30 because there are 4 itmes that are not
displayed in the drop down window. the last item i can select happens to be
in row 30. the last piece of data is actually in row 34...

2) thanks for the FYI, you are correct, it is actually pulling from row k

3) I did try this, it is still not working properly.

4) same here, it is on automatic.

Would it be possible to email it? thanks for the help.

"mike allen" wrote:

hard to tell from your info, but a few
questions/suggestions/observations
for you:
1) how do you know it stops at row 30?
2) fyi: cell D18 is looking in columnJ for exactly what is in cell B10,
then
going over to columnL and returning that value, if any; while cell B18
is
looking in columnJ for exactly what is in cell B10, then going over to
columnK and returning that value, if any. You indicated you were
pulling
info from columns J & L, not L & K as code states.
3) try naming the range on sheet1!J2:L34 and referring to that range in
your
vlookup. highlight sheet1 range J2:L34, hit 'insert' 'name' 'define'
and
type in 'mylookuprange'. then change formula to
=vlookup(b10,mylookuprange,2,false).
4) lastly, make sure you are on automatic calculate (tools, options,
calculation, automatic) or hit F9 to manually calculate potentially
un-updated results from a changed formula (30--34).
hope this helps, mike allen

"Gfunc" wrote in message
...
Hiya,
what should be a relatively simple problem is driving me craaaazy. I
have
a spreadsheet with 2 cells on vlookup:
(Cell d18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,3,FALSE)) AND
(cell B18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,2,FALSE))

My problem is that it is only looking up to row 30... not all the way
to
row 34...

to claritfy:

B10 is a drop down box where I choose which category i want.
once I click the category, it auto inputs data pulled from the data in
coulms j & L.
It is supposed to pull all the way down to the 34th row, but for some
reason, it stops at row 30... It originally was programmed to only go to
row
30, but as you can see from the formula, I have adjusted for the
addition.

Any help is greatly appreciated.

Gfunc

VLOOKUP
 

Awesome, Mike. I knew that there was some place i was forgetting to link to. That corrected the problem. I sincerely appreciate your efforts. Thanks.

Gfunc

"mike allen" wrote:

I didn't realize "it" referred to the dropdown box only going to 30. I
thought you were saying the vlookup formulas were not looking past 30. I
would say re-establish your 'data' 'validation' 'allow' 'list' by making
sure 'source' is now referring down to row 34. If 'source' is for sure
including line 34, make sure you are scrolling all the way down your
dropdown box. that's all i can think of. let me know how it goes, mike
allen
"Gfunc" wrote in message
...
Mike, thanks for the response.
1) I know it stops at row 30 because there are 4 itmes that are not
displayed in the drop down window. the last item i can select happens to be
in row 30. the last piece of data is actually in row 34...

2) thanks for the FYI, you are correct, it is actually pulling from row k

3) I did try this, it is still not working properly.

4) same here, it is on automatic.

Would it be possible to email it? thanks for the help.

"mike allen" wrote:

hard to tell from your info, but a few
questions/suggestions/observations
for you:
1) how do you know it stops at row 30?
2) fyi: cell D18 is looking in columnJ for exactly what is in cell B10,
then
going over to columnL and returning that value, if any; while cell B18
is
looking in columnJ for exactly what is in cell B10, then going over to
columnK and returning that value, if any. You indicated you were
pulling
info from columns J & L, not L & K as code states.
3) try naming the range on sheet1!J2:L34 and referring to that range in
your
vlookup. highlight sheet1 range J2:L34, hit 'insert' 'name' 'define'
and
type in 'mylookuprange'. then change formula to
=vlookup(b10,mylookuprange,2,false).
4) lastly, make sure you are on automatic calculate (tools, options,
calculation, automatic) or hit F9 to manually calculate potentially
un-updated results from a changed formula (30--34).
hope this helps, mike allen

"Gfunc" wrote in message
...
Hiya,
what should be a relatively simple problem is driving me craaaazy. I
have
a spreadsheet with 2 cells on vlookup:
(Cell d18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,3,FALSE)) AND
(cell B18) =(VLOOKUP($B$10,Sheet1!$J$2:$L$34,2,FALSE))

My problem is that it is only looking up to row 30... not all the way
to
row 34...

to claritfy:

B10 is a drop down box where I choose which category i want.
once I click the category, it auto inputs data pulled from the data in
coulms j & L.
It is supposed to pull all the way down to the 34th row, but for some
reason, it stops at row 30... It originally was programmed to only go to
row
30, but as you can see from the formula, I have adjusted for the
addition.

Any help is greatly appreciated.

Gfunc