MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Doug Gill on October 11, 2000 3:56 PM

I'm attempting to create a form for supervisors to fill out with the day's production. Somedays they may produce the same partnumber, and, if so, I've tried to us the vlookup command to get the data twice. It will reference it once but not the second time.

The problem may be tied to the table below the form. The table was copied from an Access query. Excel doesn't seem to read the Access data consistently and

Any ideas?

Thank You Very Much!

Posted by ereit on October 11, 2000 5:42 PM

I agree
I need to know how I can sum two or more figures in a Vlookup table

Posted by Mini me on October 12, 2000 4:05 AM

help meeeeee

need outputs for a hotel today
using look up if you can help cool

Posted by Celia on October 12, 2000 4:22 AM

What data do you need to retrieve from your table (e.g. total quantity of each part number)?
Need more details on what you are trying to do - VLookup may not be appropriate.

Posted by Celia on October 12, 2000 4:26 AM

Perhaps VLOOKUP is not appropriate. Have a look at the SUMIF worksheet function.

Posted by ereit on October 12, 2000 8:23 PM

Your suggestion works great.

Thank you