LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jan K
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a lookup table with an added varable? GIZZMO Excel Worksheet Functions 3 April 6th 09 10:32 PM
Automatically insert row between groups of records DWeb Excel Discussion (Misc queries) 5 April 6th 05 01:30 AM
Multiple reference for lookup in excel Andrew Excel Worksheet Functions 0 March 17th 05 01:36 PM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 02:49 AM
How do I find data from a list (or table) and insert it in a row? Bobgolfs56 Excel Discussion (Misc queries) 1 February 3rd 05 12:51 AM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"