R
rowanmantle
I am having a problem with a VLOOKUP formula. I have a cell that is
validated with a list that is the left hand column on my VLOOKUP array.
there a total of 9 columns in this this array. The array is 70 rows
long. whenever I try to get it to calculate the VLOOKUP for any of the
columns it will only display the values for the last half of the list.
Is there a limit to the length of a VLOOKUP search? Is there any way
around this? How do I get the VLOOKUP to return the values I need it to
with the whole list inclusive, not just the last half?
I'd appreciate any help I can get. Thank you
validated with a list that is the left hand column on my VLOOKUP array.
there a total of 9 columns in this this array. The array is 70 rows
long. whenever I try to get it to calculate the VLOOKUP for any of the
columns it will only display the values for the last half of the list.
Is there a limit to the length of a VLOOKUP search? Is there any way
around this? How do I get the VLOOKUP to return the values I need it to
with the whole list inclusive, not just the last half?
I'd appreciate any help I can get. Thank you