How do I insert a reference to lookup and insert a name
 

How do I insert a reference code in one column which will then look up a
reference table and then insert the name in the next column. eg if I type the
letter b in column 1 then the word 'bank' will appear in column 2. If I type
the letter i in column 1 then the word 'insurance' will appear in column 2
etc etc

look at VLOOKUP in Help.

--
HTH

Bob Phillips

"Jan K" <Jan wrote in message
...
How do I insert a reference code in one column which will then look up a
reference table and then insert the name in the next column. eg if I type
the
letter b in column 1 then the word 'bank' will appear in column 2. If I
type
the letter i in column 1 then the word 'insurance' will appear in column 2
etc etc

Try this.
In G1:G5 type b, i, s, r
In G1 type bank, insurance, stockbroker, retailer
In A1 type b
In B1 enter this formula =VLOOKUP(A1,G1:G5,2,FALSE)
It should return <bank
The other letters in A1
Read Help for VLOOKUP and HLOOKUP
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jan K" <Jan wrote in message
...
How do I insert a reference code in one column which will then look up a
reference table and then insert the name in the next column. eg if I type
the
letter b in column 1 then the word 'bank' will appear in column 2. If I
type
the letter i in column 1 then the word 'insurance' will appear in column 2
etc etc

Hi Bernard, except that bank, insurance, stockbroker, retailer should be in
H1:H5?
and the lookup formula should therefore check G1:H5
=VLOOKUP(A1,G1:H5,2,FALSE)
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Bernard Liengme" wrote:

Try this.
In G1:G5 type b, i, s, r
In G1 type bank, insurance, stockbroker, retailer
In A1 type b
In B1 enter this formula =VLOOKUP(A1,G1:G5,2,FALSE)
It should return <bank
The other letters in A1
Read Help for VLOOKUP and HLOOKUP
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jan K" <Jan wrote in message
...
How do I insert a reference code in one column which will then look up a
reference table and then insert the name in the next column. eg if I type
the
letter b in column 1 then the word 'bank' will appear in column 2. If I
type
the letter i in column 1 then the word 'insurance' will appear in column 2
etc etc