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!

Need assistance with formula
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Credit summation formula - Guide

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

You have guessed the code too many times. Contact support

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!