+ Reply to Thread
Results 1 to 7 of 7

Matching post codes to areas

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Matching post codes to areas

    Hi

    Can some help me on attached spreadsheet. I'm trying to show spend against each area ( 4 in total). I'm basic user in Excel and I have no idea how to use correct formula.

    On left cells in spreadsheet I have 4 areas with post codes. In the middle I've got a post codes where we spend a money. I need to match that figures. Can someone help ?
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Matching post codes to areas

    Still I am not clear what needs to be done and what is your query is

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Matching post codes to areas

    It's hard to explain. If you look into my spreadsheet you will see first 4 columns with areas. Columns in the middle are the post codes which I'm trying to match to areas and show spend in each of them. For example if I type post codes in column G it will match what area it is and provide spend in column either column L,M,N,O ( depand what area will match). Is there any formula or do I need to change all layout ?

    In summary I need to show how much money we are spending as company in which area. In column G post codes are match with our suppliers.

    Is that more clear now?

  4. #4
    Registered User
    Join Date
    05-08-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Matching post codes to areas

    Can you help as it's really important task I've been given today at work

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,860

    Re: Matching post codes to areas

    Hi,

    None of the postal codes in Col G match any of the code in Col A through Col D. Did you know that? Are you giving us the entire table of postal codes? Do we need to use a partial code in Col G?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  6. #6
    Registered User
    Join Date
    05-08-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Matching post codes to areas

    Yes, you should only use part code and than they should match. Purpose of this spreadsheet is to show our spending with a local suppliers.Post codes from column A,B,C and D are complete. If non of the post code in column G not matching should not be counted. On columns L,M,N,O I'm trying to get a formula which will automatically check post code from columd G and if true put in correct column with amount money spend againt it.

    For example if one of the post codes in column G will be DE7 0 than formula will automatically put this into column M ( as this is area 2 ) but instead of putting post code it will show amount spend.

    Hope this explain more.

  7. #7
    Registered User
    Join Date
    05-08-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Matching post codes to areas

    Post codes in columng G will be changing on monthly routine

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1