Previous Topic Next Topic

Need assistance with formula

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

Hi,

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:
=IF(B2>0,VLOOKUP(B2,comments,3,FALSE),"")

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

Can you help please!

1 response

Answer 1 / 1
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?
Nira
Nov 26, 2010 at 09:54 AM
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?
Nira
Nov 26, 2010 at 10:53 AM
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!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses