Sub-Total and VLookup problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have correctly set up both sub-total and Vlookups in various spreadsheets,
but these functions are not working properly. The sub-totals (using sum
function) adds to zero, and the vlookups do not recognize matches that I know
exist. I've consulted many people, and all do not have an answer. Can you
help?
 
Hi
sounds like an format issue. Probably your values are actually text.
What does the following formula return
=ISNUMBER(A1)

Where A1 is one of your value cells

Also if you think you have a match check it directly with
=A1=X1
and see if this formula really returns TRUE.
 
You must log in or register to reply here.

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

vlookup of sub totals 2
Sum Vlookup where there are blanks 1
vlookup to a word in a cell 1
Can't Explain N/A in Vlookup 2
Vlookup issues 2
IF/VLOOKUP with #N/A results 6
Vlookup formulas with criteria 5
Sub total in exce 2000 1

Back
Top