Problem with Vlookup

S

srosetti

Maybe there is a restriction on the number of cells I can search I
don't know..

=VLOOKUP(A53078,$G$2:$H$84,1,FALSE) returns a result of #N/A

when I copy that same formula to an entry for like the first 1000
entries it returns a result, but beyond it seems to not be working..
Is there a limit?? Is there a problem with my formula?

The lookup Table lives from G2:H84 and its sorted AtoZ I want to
return the result to this particular cell from column one in my
table.. It should be checking Value in A53078 against my table..

ideas?
 
S

srosetti

Maybe there is a restriction on the number of cells I can search I
don't know..

=VLOOKUP(A53078,$G$2:$H$84,1,FALSE) returns a result of #N/A

when I copy that same formula to an entry for like the first 1000
entries it returns a result, but beyond it seems to not be working..
Is there a limit??  Is there a problem with my formula?

The lookup Table lives from G2:H84 and its sorted AtoZ  I want to
return the result to this particular cell from column one in my
table..  It should be checking Value in A53078 against my table..

ideas?

correction. It will return a value up to 3,300 entries, but after
that.. #N/A
 
S

srosetti

Turns out Vlookup can't handle quotes for my check cell. It turns out
the first 3300 entries dont have those quotes. Now to get rid of
them.. ideas? I might have a formula already.. but I'm all ears if
you have a suggestion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top