Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP not retrieving all information
I seem to be having trouble with my vlookup formula not retreiving all of the
requested data for an array of cells. I enter my vlookup as usual, select the array of cells in another workbook as usual, and when I copy the formula down, it returns #N/A for a few of the cells located at the bottom of the list. I then gather all of cells with missing information that the vlookup formula failed to gather, enter the same formula for the same array of cells, and this time, the formula gathers a little more information that it missed from the last time. I have to keep sorting and entering in a new formula until all information is retrieved. Any help is appreciated. Thank you. -- -Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup without Unique information | Excel Discussion (Misc queries) | |||
VLookup returning more than one Row of information | Excel Worksheet Functions | |||
retrieving information | Excel Discussion (Misc queries) | |||
vlookup truncating information | Excel Worksheet Functions | |||
Retrieving information for a day of the week... | Excel Worksheet Functions |