Thread
:
How do I insert a reference to lookup and insert a name
View Single Post
#
2
Bob Phillips
Posts: n/a
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
Reply With Quote