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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP not retrieving all information
Try to make sure the array is using an absolute reference with dollar signs
before you copy the formula down or else your array will be a moving target. Use a formula like this: vlookup(a1, $B$1:$C$100, 1, false) Avoid a formula like this: vlookup(a1, B1:C100, 1, false) "Nick" wrote: 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 |
Reply |
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 |