Can i do this with a VLookup?

		Microsoft Office Forums > Microsoft Excel > Excel
Can i do this with a VLookup?

01-21-2011, 12:34 AM

macropod

Windows 7 32bit Can i do this with a VLookup?

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,478

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]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
Using IF & VLOOKUP together	junction	Excel	7	11-18-2010 05:15 AM
Help with VLOOKUP	sakhtar	Excel	2	07-24-2010 07:39 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM
vlookup question	Tony G	Excel	9	03-28-2009 11:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:45 AM.