filling other cells based on a postcode?

[Dayveez]

A1---------- A2------------- A3
Postcode--- County-------- Country

<table style="width: 342px; height: 49px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:5961;width:122pt" width="163"> <col style="mso-width-source:userset;mso-width-alt:9106;width:187pt" width="249"> </colgroup><tbody><tr style="height:21.0pt" height="28"> <td class="xl63" style="height:21.0pt;width:48pt" width="64" height="28">BT32
</td> <td class="xl63" style="width:122pt" width="163"> County Down
</td> <td class="xl63" style="width:187pt" width="249"> England
</td> </tr> <tr style="height:21.0pt" height="28"> <td class="xl63" style="height:21.0pt" height="28">BT33</td> <td class="xl63"> ?</td> <td class="xl63"> ?
</td> </tr> <tr style="height:21.0pt" height="28"> <td class="xl63" style="height:21.0pt" height="28">BT34
</td> <td class="xl63"> County Down
</td> <td class="xl63"> England
</td> </tr> </tbody></table>
I have a database of UK postcodes on a excel sheet with all the counties and countries next to them.
I want to put in a postcode in any cell for example: BT33, and want it to automatically tell me next to it in 'A2' that its 'county down' and in 'A3' that its 'England'.
..So that i dont have to keep typing 'county down' and 'england' every time someone calls me from that area and i input their details. Instead want to just type BT33 and it comes up.

Please help.

 

[Dayveez]

ok ill give you a picture of what i have of what i was supposed to do. I put all the formulas where they supposed to be. I just think the formula is wrong. please see what you make of it.

http://www.freeimagehosting.net/vgpwb

 

[Oeldere]

The formula is good.

I supposte you get ? as answer.

In that case it's ok, because c4 is "?"

Can you explain what's the problem.

Otherwise upload the data instaed of a picture.

 

[Dayveez]

I want to put post code in then the town and county appears.

Ok give you a fresh picture that you will understand instead of my own example.
This is part of my project.

http://www.freeimagehosting.net/qbtjq

 

[Oeldere]

The first time you fill the list manualy.

After that you can use the data in the list with a Vlookup function.


The list needs to be sorted from low to high.

If not sorted right the Vlookup function won't work well.

 

[Dayveez]

I cant put my list in order low to high. Its mostly letters.

 

[Smitty]

If you follow the HTML maker link in my sig you'll be able to post working shots of your sheets. From there someone can help set you up with a VLOOKUP based on your setup.

 

[Dayveez]

do i have to download anything to go with it? neither of them will open with excel 2007 or this xml converter thing its default to open with.

 

[Smitty]

Yes, you have to download the add-in, then install it. There's a Word doc at the download location that explains how to do it.