Macro formula to match two columns and Produce result in fourth column.

**rishi1983** · 04-29-2012, 07:23 PM

Hi,
I'm a newbee in Excel programming and macros. I need help creating a Macro formula to match two columns (A & C) and if there's a match, I want it to produce the value that's in column B(right next to column C), into column D. I tried using Vlookup but no luck. So need excel macro code.
Please find sample attached.
Note : All the values will be basically text and not numbers.(in sample you may find some numbers)

Thanks for your help & time.

Awaiting your response back.

Regards,
Roger

**AlvaroSiza** · 04-29-2012, 08:02 PM

I'm confused. Did you supply the "D" column values in the sample to show what the result of a to-be-produced macro would achieve? As it stands in the sample workbook, I cannot find the logic necessary to address your request. Please clarify.

**FDibbins** · 04-29-2012, 08:21 PM

add this to D1, and copy down. I assumed that if there was no match, you would no want to show anything.

=IF(ISERROR(VLOOKUP(C1,$A$1:$B$11,2,FALSE)),"",VLOOKUP(C1,$A$1:$B$11,2,FALSE))

if you do want to show something for a non-match, use this...

=IF(ISERROR(VLOOKUP(C1,$A$1:$B$11,2,FALSE)),"whatever-you-want-to-show",VLOOKUP(C1,$A$1:$B$11,2,FALSE))

**rishi1983** · 04-29-2012, 10:43 PM

Hi Alvarosiza - Yes. You are correct. Column D values are the values I'm trying to achieve.

FDibbins - I tried your formula. But they are not maching my original column D values.

Please advise.

Once again thanks for your support. Appreciate it.

**FDibbins** · 05-03-2012, 08:50 PM

thats because you had double entries for "chips", which cavlue would you want matched? the others all match because there is only 1 instance of the "item"

see the attached...