Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup not working
Also I am using =VLOOKUP(J5,'Ship List'!A$1:B$30,2,FALSE) to look in column A
on another worksheet (Ship List) and return the value in column B. I have successfully used vlookup before. Column A in Ship List is sorted and I have tried formatting both the lookup value and Col A from the lookup array as text, general, number. However only a few cells return matches. Also I have made sure the lookup val and Col A are the same length. The lookup value is a 5 digit number. Any ideas? Thanks, Joe M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup not working
Try:
=VLOOKUP(TEXT(J5,"00000"),'Ship List'!A$1:B$30,2,0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Joe M." wrote: Also I am using =VLOOKUP(J5,'Ship List'!A$1:B$30,2,FALSE) to look in column A on another worksheet (Ship List) and return the value in column B. I have successfully used vlookup before. Column A in Ship List is sorted and I have tried formatting both the lookup value and Col A from the lookup array as text, general, number. However only a few cells return matches. Also I have made sure the lookup val and Col A are the same length. The lookup value is a 5 digit number. Any ideas? Thanks, Joe M. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup not working
Sounds like the numbers in your lookup table were entered as Text
(changing the formatting doesn't change that). Try copying an empty cell, selecting the numbers, then choose Edit/Paste Special, selecting the Values and Add radio buttons. This should coerce Text numbers to actual numbers. In article , Joe M. wrote: Also I am using =VLOOKUP(J5,'Ship List'!A$1:B$30,2,FALSE) to look in column A on another worksheet (Ship List) and return the value in column B. I have successfully used vlookup before. Column A in Ship List is sorted and I have tried formatting both the lookup value and Col A from the lookup array as text, general, number. However only a few cells return matches. Also I have made sure the lookup val and Col A are the same length. The lookup value is a 5 digit number. Any ideas? Thanks, Joe M. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup not working
more genaric
=if(iserror(Vlookup(J5,'Ship List'!A$1:B$30,2,0)),if(iserror(VLOOKUP(TEXT(J5,"0 0000"),'Ship List'!A$1:B$30,2,0)),vlookup(value(J5),'Ship List'!A$1:B$30,2,0),VLOOKUP(TEXT(J5,"00000"),'Ship List'!A$1:B$30,2,0)),Vlookup(J5,'Ship List'!A$1:B$30,2,0)) "Max" wrote: Try: =VLOOKUP(TEXT(J5,"00000"),'Ship List'!A$1:B$30,2,0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Joe M." wrote: Also I am using =VLOOKUP(J5,'Ship List'!A$1:B$30,2,FALSE) to look in column A on another worksheet (Ship List) and return the value in column B. I have successfully used vlookup before. Column A in Ship List is sorted and I have tried formatting both the lookup value and Col A from the lookup array as text, general, number. However only a few cells return matches. Also I have made sure the lookup val and Col A are the same length. The lookup value is a 5 digit number. Any ideas? Thanks, Joe M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup not working | Excel Worksheet Functions | |||
Vlookup not working for me. | Excel Worksheet Functions | |||
VLOOKUP NOT WORKING | Excel Discussion (Misc queries) | |||
vlookup working sometimes, sometimes not | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |