Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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) |