| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP problem
Hey peeps, Do you have any idea what is wrong with this formula "=VLOOKUP(A2,'Supplier list'!$A$2:$M$9710,2,FALSE)"? The value it is extracting with is not blank but is a text. -- Seeking help ------------------------------------------------------------------------ Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658 View this thread: http://www.excelforum.com/showthread...hreadid=569331 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP problem
Could this simply be an issue with a text value having a space at the end in
cell A2? If not can you see the value in A2 in the list you;re looking up? "Seeking help" wrote: Hey peeps, Do you have any idea what is wrong with this formula "=VLOOKUP(A2,'Supplier list'!$A$2:$M$9710,2,FALSE)"? The value it is extracting with is not blank but is a text. -- Seeking help ------------------------------------------------------------------------ Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658 View this thread: http://www.excelforum.com/showthread...hreadid=569331 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP problem
I suggest you should try the "trim" function on your lookup value and then
use vlookup. there might be some blank spaces at d beginninng or end of text because of which you are not getting wht you want. Regards "DaveO" wrote: Could this simply be an issue with a text value having a space at the end in cell A2? If not can you see the value in A2 in the list you;re looking up? "Seeking help" wrote: Hey peeps, Do you have any idea what is wrong with this formula "=VLOOKUP(A2,'Supplier list'!$A$2:$M$9710,2,FALSE)"? The value it is extracting with is not blank but is a text. -- Seeking help ------------------------------------------------------------------------ Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658 View this thread: http://www.excelforum.com/showthread...hreadid=569331 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup problem | Excel Discussion (Misc queries) | |||
| Vlookup problem with Date Time | Excel Worksheet Functions | |||
| vlookup Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Problem | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Linear Mode
