| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
I am trying to vlookup 2 sheets but because some of the cell have extra space
hence formula isnt working. I tried to eliminate the space by data text delimited check space, but the cell is types as eg USA Mobile, USA Landline etc, and the above text function will also separate the USA and and mobile & landline..... Any advise? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup
Well, this seems like a completely different post, but it isn't any
clearer to me. Please list examples of what you have (and the cell/ column references), together with what you want to do with it. Pete On Sep 2, 4:34*pm, Salman wrote: I am trying to vlookup 2 sheets but because some of the cell have extra space hence formula isnt working. I tried to eliminate the space by data text delimited check space, but the cell is types as eg USA Mobile, USA Landline etc, and the above text function will also separate the USA and and mobile & landline..... Any advise? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup
Pete, Thanks for the reply. I managed to resolve the problem by using 'trim'
function on the source sheet. "Pete_UK" wrote: Well, this seems like a completely different post, but it isn't any clearer to me. Please list examples of what you have (and the cell/ column references), together with what you want to do with it. Pete On Sep 2, 4:34 pm, Salman wrote: I am trying to vlookup 2 sheets but because some of the cell have extra space hence formula isnt working. I tried to eliminate the space by data text delimited check space, but the cell is types as eg USA Mobile, USA Landline etc, and the above text function will also separate the USA and and mobile & landline..... Any advise? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup
Okay, glad you resolved the problem - thanks for feeding back.
Pete On Sep 3, 11:53*am, Salman wrote: Pete, Thanks for the reply. I managed to resolve the problem by using 'trim' function on the source sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
