Vlookup?
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
correctly.
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
ereit@home.com
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
Doug
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.
Celia
Posted by Celia on October 12, 2000 4:26 AM
ereit
Perhaps VLOOKUP is not appropriate. Have a look at the SUMIF worksheet function.
Celia
Posted by ereit on October 12, 2000 8:23 PM
Celia
Your suggestion works great.
Thank you
ereit
