| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting text from one file to another
Is there a way to use VLookup to extract text? I have a PN on my current
worksheet that I'd like to lookup in another, then pull the text comments from the other worksheet. VLookup only pulls numbers instead of text. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting text from one file to another
Vlookup delivers anything that is in the column you told it to take a
value from. =Vlookup(a5;range;4;false) looks up the search value in A5 in the table named "range" and puts what it finds in column 4 of the line where it found the search value into the cell of your formula. Hans |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Opening a text file | Excel Discussion (Misc queries) | |||
| can I display the file name of the imported text file in another c | Excel Discussion (Misc queries) | |||
| How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
