MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Please .... Search, Match and compare

Posted by Marc Hennebery on May 11, 2001 1:39 PM

I have two workseets that come from two different sources. I need to match an Item number in column A of Sheet1 with Column A of Sheet2. When there is a match found, I need to place the two item numbers along with the data found in Column I of Sheet1 and Column G of Sheet2 of the matching records in a row on Sheet3. Can this be done with a macro, or is this something better done with a formula? Please help me out with this.

Posted by Kevin James on May 11, 2001 4:00 PM

Take a look at the syntax for VLookup.

Posted by Tim on May 11, 2001 5:07 PM

You can use VLookup function to extract data from other cells or from other files for that matter, based on a specific "Item Number". The trick to doing this is to have both worksheets open when you are creating the vlookup formula.

Hope this helps!