| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Contains text
=VLOOKUP(MID(A2,9,3),Munka9!A2:B4,2,FALSE)
Column A Column B Reciever Reciever111 AA =VLOOKUP(MID(A2,9,3),Sheet2!$A$2:$B$4,2,FALSE) Reciever122 AA Reciever111 AB Sheet2: A B Reciever: Latest Delivery Time: 111 12:00 122 11:30 133 11:30 Regards, Stefi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
| Conversion to Text file format error | Excel Discussion (Misc queries) | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
