Excel 2007 : VBA script needed?

**mapu** · 05-10-2011, 07:40 PM

Hello,

I've had this issue and have not found a way around it.

The programs I have available to me are excel 2007 and msaccess 2003.

I have a spreadsheet, it contains postcodes in column A; city region in column B; in column C there is another set of postcodes; column D is empty

The data in column A and B are matching the postcodes to the city region. I need to have a lookup so that column C can find it's match in column A, then the corresponding city region in column B needs to be placed in column D, next to the postcode in column C that matched.

Is there a way to do this without VBA?

**Richard Buttrey** · 05-10-2011, 08:20 PM

Hi,

Almost certainly, but you'd be better advised to upload an example workbook so that we can see the request in context. Add some examples so that we can see the results you expect.

Regards

**mapu** · 05-10-2011, 08:48 PM

Originally Posted by Richard Buttrey

Hi,

Almost certainly, but you'd be better advised to upload an example workbook so that we can see the request in context. Add some examples so that we can see the results you expect.

Regards

Attached thanks.

By the way, using VBA is a problem which is why I haven't gone this way. I'm not sure if there's a solution using msaccess or excel 07 but if there is I am willing to throw a couple of $ your way for your help.

**Richard Buttrey** · 05-11-2011, 03:22 AM

Hi,

In D2 copied down

Please Login or Register  to view this content.

if you have Excel 2007 or later this can be simplified to

Please Login or Register  to view this content.

**mapu** · 05-12-2011, 07:29 PM

Originally Posted by Richard Buttrey

Hi,

In D2 copied down

Please Login or Register  to view this content.

if you have Excel 2007 or later this can be simplified to

Please Login or Register  to view this content.

I can't express how happy I am to have found such a simple solution.

You're amazing thank you so much!

Excel 2007 : VBA script needed?

LinkBack

Thread Tools

Rate This Thread

Display

VBA script needed?

Re: VBA script needed?

Re: VBA script needed?

Re: VBA script needed?

Re: VBA script needed?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions