Porirua Wrote:
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


Let's assume that your table is in Sheet1 and you will enter your post
code in Cell A2, Sheet 2. Let us further assume that your table range
(in sheet 1) is A2:K12000.

With the above assumptions, here are the formulas that you will enter
in the following cells in Sheet 2:

B2 : =vlookup(A2,Sheet1!$A$2:$K$12000,2,0)
C2: =vlookup(A2,Sheet1!$A$2:$K$12000,3,0)
D2: =vlookup(A2,Sheet1!$A$2:$K$12000,4,0)
E2: =vlookup(A2,Sheet1!$A$2:$K$12000,5,0)
F2: =vlookup(A2,Sheet1!$A$2:$K$12000,6,0)
G2: =vlookup(A2,Sheet1!$A$2:$K$12000,7,0)
H2: =vlookup(A2,Sheet1!$A$2:$K$12000,8,0)
I2: =vlookup(A2,Sheet1!$A$2:$K$12000,9,0)
J2: =vlookup(A2,Sheet1!$A$2:$K$12000,10,0)
K2: =vlookup(A2,Sheet1!$A$2:$K$12000,11,0)

Hope this is what you are looking for.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=381022