Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
Automatically insert row between groups of records | Excel Discussion (Misc queries) | |||
Multiple reference for lookup in excel | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
How do I find data from a list (or table) and insert it in a row? | Excel Discussion (Misc queries) |