Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-20-2011, 12:25 PM
foodstudent foodstudent is offline Can i do this with a VLookup? Windows XP Can i do this with a VLookup? Office 2003
Novice
Can i do this with a VLookup?
 
Join Date: Jan 2011
Posts: 1
foodstudent is on a distinguished road
Lightbulb Can i do this with a VLookup?

Hello

I am working on a spreadsheet, and need to convert a list of suppliers materials on different rows, so they are displayed in columns, if this makes sense



- I have attached a spreadsheet showing the issue.

I need to get the "Overview" sheet to list the materials each supplier supplies in horizontal order, I have done V lookups on the first two sheets, so the material supplied is on the "supplier and codes" tab and the supplier is on the "Codes and Materials" tab.

The reason behind doing this is so that I can send out an email (as a mail merge) and the supplier will recieve one email with a list of materials rather than several emails, one for each material.

Hope someone can help me... it would literally save me DAYS!!!!
Attached Files
File Type: xls Excel Problem.xls (33.5 KB, 17 views)
Reply With Quote
 

Tags
excel 2003, vlookup



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
Can i do this with a VLookup? 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 02:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft