MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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