Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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"?

excel
MS Office Version: Kbell
posted by: Kbell on Mon Feb 12, 2018 at 3:03 pm
Answer
Discuss

Discussion

please edit your question and attach a sample workbook - this could be happening for many different reasons.
don (rep: 1989) 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!

posted by: Variatus (rep: 4889) on Tue Feb 13, 2018 at 4:49 am
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