| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Post Code search
Hi everyone, I am new to excel and have been given a task which is currently beyond my capabalities and seek help from all you experts out there. I have about 12000 postcodes in column A and columns B to K contain miscallaneous information relating to each postode, ie name, address, tel, fax etc What I would like is help with a formula whereby I would type in the postcode and the information would search and display the details in columns B to K for that particular postcode. I am aware the easiset option is to use the edit and find function, however ideally I would like to use sheet two for the search. I would appreciate any help, thanks in advance Porirua -- Porirua ------------------------------------------------------------------------ Porirua's Profile: http://www.excelforum.com/member.php...o&userid=24505 View this thread: http://www.excelforum.com/showthread...hreadid=381022 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| post code on col1 & list of suburbs in col2 - what is the formula | Excel Discussion (Misc queries) | |||
| Post code & Suburbs | Excel Discussion (Misc queries) | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Code Post: Extract Trendline coefficients | Excel Discussion (Misc queries) | |||
Threaded Mode
