[QUAR] Excel or Access Gurus

vlookup function


From: Jonathan Lang [mailto:lsbestinc@...]
Sent: Tuesday, March 10, 2009 6:57 AM
To: vantage@yahoogroups.com
Subject: [QUAR] Re: [Vantage] Excel or Access Gurus
Importance: Low

Sorry, My mail sent itself before I fininshed. I need all of the
information for 2007 and 2008 on each part number. Any ideas?

--- On Tue, 3/10/09, Jonathan Lang < lsbestinc@...
<mailto:lsbestinc%40yahoo.com> > wrote:

From: Jonathan Lang < lsbestinc@... <mailto:lsbestinc%40yahoo.com>
Subject: [Vantage] Excel or Access Gurus
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Tuesday, March 10, 2009, 8:55 AM

It's days like this one that I just want yell, "WHY ME!"

Okay, here it is.

I need to combine two seperate Excel sheets with similar data. Here is
what I have in an example.

2007) Part Num, Acct No, Yr 2007 Price, 2007 Extended Price

2008) Part Num, Acct No, Yr 2008 Price, 2008 Extended Price

I need to have all of the data on the same excel sheet, BUT the part
Numbers have to match up and the 2007 and 2008 data for the part

For example using the headings above:

A1234 1000

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

NOTICE OF CONFIDENTIALITY: This e-mail message, including attachments, is for the sole use of the intended recipients and may contain confidential and privileged information. If you are not an intended recipient, please contact the sender by reply e-mail and destroy all copies of this message, including attachments. Any unauthorized review, use, disclosure or distribution is prohibited.