| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup not working
I have one column having many abbreviated name which I want to change to its
full name in other column like A,AL,CS,RP,TQ,NSD,PORT,DKL and so on which is to be changed to Auckland, Aliappa, Castariaca, Rosepet,Time qou,Nasdon,Portariac,Docklone I tried with =lookup(a1,{"A","AL"},{"Auckland","Aliappa"}) it replace some name but some wrong replacing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP is working - but VLOOKUP is not | Excel Discussion (Misc queries) | |||
| LOOKUP function Problem | Excel Worksheet Functions | |||
| Lookup problem | Excel Worksheet Functions | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup function help | Excel Worksheet Functions | |||
Threaded Mode
