Need assistance with formula

Nira - Nov 25, 2010 at 03:27 PM
 Nira - Nov 26, 2010 at 10:53 AM


I have a spread sheet that helps me keep track of A/R and notes. On one sheet I have a columns with invoice #, description, notes. on the second sheet I pull information from the accounting software (columns in order - client name, invoice #, description, amount, notes). The second sheet has a formula for description: =IF(B2>0,VLOOKUP(B2,comments,2,FALSE),"")

and for notes:

The problem is it only works up to invoice #6569, anything after that returns with #N/A

Can you help please!

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 26, 2010 at 04:33 AM
It looks "comments" the second argument in vlookup is the name of a range.
check whether this rane covers all the data?
Hi, Thanks for you answer. The "comments" is the name of the 2nd spread sheet. for some reason the formula works up until number 6569 anything after that doesn't. I don't see any set range in the formula. if there is one, how could a check that?
I copied and pasted data in a new file so I can play around with it and now it work up to invoice # 6588! I was testing to see up to which number the formula works by entering one by one greater than the other (6569, 6570, 6571, etc) . When I skipped a few numbers (eg if 6571 works, try 6579) it would sometimes return #N/A, but then if I go back and type 6572, 6573,6574, etc, I was eventually able to get a return for 6579 ( as long as I was testing in the same order....) (by testing I mean entering the number in the same cell, and re-entering the next number).

I am really confused!!!! I hope someone can help me with this pleaseeeeee

Thanks for your time!