Search : in
By :

Excel question

Last answer on Nov 6, 2009 12:16:41 pm GMT Cando, on Nov 5, 2009 12:45:05 pm GMT 
 Report this message to moderators

Hello,
I receive an order report (spreadsheet) from my customer that only has their part numbers & on a separate spreadsheet I have a cross reference list (their part # to my part #.

How can I use VLOOKUP to add my part # to their order report?

Configuration: Windows XP Internet Explorer 8.0

Best answers for « Excel question » in :
Spreadsheets - The Excel Interface Show Excel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Download Excel Viewer Show
How to convert Excel into PDF? Show How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download Excel Password Recovery Master Show
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Ask your question Reply

2

 Trowa, on Nov 6, 2009 12:16:41 pm GMT
  • +1

Hi Cando,

Have you checked the help function or even looked at the syntaxis?

Vlookup: The value you are looking for, The matrix you want to look in, The column of the matrix containing the desired result.

If you are still having trouble, tell me how your sheet is build up, so I can give you a specific formula.

Best regards,
Trowa

   
Reply to Trowa
Ask your question Reply
They need your help