Thread: [Solved] Can i do this with a VLookup?
View Single Post
 
Old 01-21-2011, 12:34 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi foodstudent,

Essential, what you want to do is to have a series of lookups for each supplier that works with multiple entries per supplier. The formulae for this are quite complex. To see what's involved, have a look at the worksheets attached to my posts at:
http://lounge.windowssecrets.com/index.php?showtopic=771787
and:
http://www.techsupportforum.com/microsoft-support/microsoft-office-support/375768-excel-formula-issues.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote