| 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. |
| 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 | |||
Threaded Mode
