VLOOKUP

S

Simon Tarlovsky

My lookup querry works well up to some range, under it it replys values of 0.
Have you seen this before? I solved previously by changing the range from
$a$a:$j$j to a1:j999 I got the range with non 0 answers extended but not for
long
 

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

Make VBA ComboBox_Change work in 3 sheets 1
Search an array of sheets for an array of numbers & return count of numbers 11
Modify working code to expand the output. 5
Too much data for this code? 4
conditional format based on column statistics and loop over columns 1
VLookup using VB 5
Runtime Error 1004 on Linest 7
Runtime Error 1004 on Linest in VBA 1

Top