Excel is looking at the numbers wrong

0

I have a workbook that feeds information from each worksheet into another worksheet.  On the customer tab you have to number the customer and then enter the information.  It worked fine with customers 1-9, but when I entered customer 10 Excel only sees the one and keeps picking up customer number 1 info where customer 10 info should be.  This is a problem because it's generating invoices and the wrong customer number being used is creating invoices to the wrong customer. 

How do I get excel to recognize "10" as "10" and not "1"?

Answer
Discuss

Discussion

please edit your question and attach a sample workbook - this could be happening for many different reasons.
don (rep: 1492) Feb 12, '18 at 6:22 pm
Add to Discussion

Answers

0

Small error, big difference. The culprit is in the formula in cell Invoice!C4. This is the corrected version.

=IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain,2,FALSE),CustomerList,3,FALSE),"")

Your original was looking for an approximate match in the outer VLOOKUP, with the Range_Lookup specified as TRUE. I changed it to FALSE and everything seems to work as advertised.

Beautiful workbook, BTW. Very nicely done!

Discuss

Discussion

I've added the workbook to my original question
Kbell Feb 13, '18 at 9:20 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login