Macro to Lookup and Output to new sheet

**Ray789** · 08-29-2010, 12:38 PM

Hi,

I have a number of headings in column 5 which have data below them. I want a Macro which will take the 'ID' and 'Name' from Sheet 1 and compare it against the 'ID' and 'Full Name' from Sheet 2 displaying the following output in Sheet3:

- ID (Column A) and Name (Column B) from Sheet1
- In Column 3 I am expecting the following 3 results:
- ID does not exist in Sheet2
- Match (When the ID exists in Sheet 2 and the corresponding Names match)
- Does not Match (When the ID exists however the 'Full Name' in Sheet2 does not match the Name from Sheet1.

I have attached a sample copy of what I am expecting.

**Richard Buttrey** · 08-29-2010, 01:36 PM

Hi,

You don't need a macro, (unless you also want the macro to extract the sheet 1 IDs and names from sheet1 to the Output sheet). Just put the following in D3 on the Output sheet and copy down.

Please Login or Register  to view this content.

HTH

**Henry Kolding** · 08-30-2010, 03:36 AM

Why are you posting in the thread of another member?

Please read the rules and start your own thread.

I am removing the attachment

Rgds

Hi there,

I am the beginner and have this table of database. I need to use the Code, Type and Service, so the output will be the one coresponded to those three arguments. E.g.

Code: AA1234
Type: A736
Service: 1M

-> Output: 184

May I know the default function that I can use in excel and/or UDF in vba so I would able to enter the arguments to get the output i.e. =Quantity(AA1234,A736,1M). Output = 184

I had used combination of vlookup() and match() but i think it can only have one header whereas mine is two.

Attached the table. Thanks.

**Ray789** · 08-30-2010, 07:42 AM

I wasn't aware I was posting into a thread of another member.

I do want the Macro to extract the ID and Names from Sheet1. Macro would be far easier than doing the copy down since I have to do this task once every day.

**Richard Buttrey** · 08-30-2010, 09:24 AM

Sorry Ray,

I saw the details were different to the original request and incorrectly assumed it was someone else posting.

However the details are different to your original question so it would be better as a new thread.

Regards

**Ray789** · 08-30-2010, 01:38 PM

Thanks for clarifying. Would it be easy to convert your solution into a Macro? Has an sample attachment been added which has now been removed?

**Henry Kolding** · 08-31-2010, 01:15 AM

Sorry I just joined and assume it is similar case so can just post it here . Okay thanks for the reminder. I shall start my own thread then.

**Ray789** · 08-31-2010, 06:22 AM

Ok well I am still waiting for a solution so you could keep checking this thread to see if the fix works for you too.

**Richard Buttrey** · 08-31-2010, 06:46 AM

Hi,

Does the formula I originally gave not work?

If you want this automated just get a macro to populate column C of the Output sheet with the formula.

Rgds