| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook
hi,
could you help me with this form ? : =VLOOKUP(L9999;[CORA1.xls]Sheet1!$C$954:$H$1130;6;FALSE) The value looked up is for example "CORDOBA" but it sometimes not found due value in cell is "CORDOBA " ( same text but followed by blank spaces ). How can I solve this ? thks and regards Jorge |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlook
=VLOOKUP(trim(L9999);[CORA1.xls]
-- Don Guillett SalesAid Software "kiki" wrote in message ... hi, could you help me with this form ? : =VLOOKUP(L9999;[CORA1.xls]Sheet1!$C$954:$H$1130;6;FALSE) The value looked up is for example "CORDOBA" but it sometimes not found due value in cell is "CORDOBA " ( same text but followed by blank spaces ). How can I solve this ? thks and regards Jorge |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlook
One option would be to trim the lookup column with the TRIM function, then
copying and pasting values back into the lookup column. Dave -- Brevity is the soul of wit. "kiki" wrote: hi, could you help me with this form ? : =VLOOKUP(L9999;[CORA1.xls]Sheet1!$C$954:$H$1130;6;FALSE) The value looked up is for example "CORDOBA" but it sometimes not found due value in cell is "CORDOBA " ( same text but followed by blank spaces ). How can I solve this ? thks and regards Jorge |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlook
Apply the TRIM function, like this:
=VLOOKUP(TRIM(L9999);[CORA1.xls]Sheet1!$C$954:$H$1130;6;FALSE) Hope this helps. Pete kiki wrote: hi, could you help me with this form ? : =VLOOKUP(L9999;[CORA1.xls]Sheet1!$C$954:$H$1130;6;FALSE) The value looked up is for example "CORDOBA" but it sometimes not found due value in cell is "CORDOBA " ( same text but followed by blank spaces ). How can I solve this ? thks and regards Jorge |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlook
Hi Jorge:
Try one of these CSE (control shift enter) formulas: =VLOOKUP($E$1,LEFT($B$1:$C$2,LEN($E$1)),1,FALSE) =VLOOKUP($E$1,TRIM($B$1:$C$2),1,FALSE) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "kiki" wrote: hi, could you help me with this form ? : =VLOOKUP(L9999;[CORA1.xls]Sheet1!$C$954:$H$1130;6;FALSE) The value looked up is for example "CORDOBA" but it sometimes not found due value in cell is "CORDOBA " ( same text but followed by blank spaces ). How can I solve this ? thks and regards Jorge |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help about vlook | Excel Worksheet Functions | |||
| use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
| Subject: vlook up 1/25/2006 1:39 PM PST | Excel Discussion (Misc queries) | |||
| vlook up | Excel Discussion (Misc queries) | |||
| How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) | |||
Linear Mode
