Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
empty cells in a vlookup list
I am currently using vlookup functions to pull data out of a list that is
about 10,000 rows long. I have created a template where I can paste the lookup data array in to this template each time so that my list above can be populated automatically from the vlookup array. Sometimes the data I will paste in will be only 8,000 rows long (just an example), so there will be around 2,000 blank rows still highlighted as the "array" from the vlookup formulas. If there are blank cells in the lookup array, does this affect rersults at all? It's impossible for me to check each result, so I just want to make sure this won't affect anything I am doing. I assume it does not, but wanted to have all my bases covered before I submit this data for analysis. Thanks in advace, PM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
empty cells in a vlookup list
Hi
Provided your Vlookup includes the 4th parameter of False or 0 you should be OK. -- Regards Roger Govier "pm" wrote in message ... I am currently using vlookup functions to pull data out of a list that is about 10,000 rows long. I have created a template where I can paste the lookup data array in to this template each time so that my list above can be populated automatically from the vlookup array. Sometimes the data I will paste in will be only 8,000 rows long (just an example), so there will be around 2,000 blank rows still highlighted as the "array" from the vlookup formulas. If there are blank cells in the lookup array, does this affect rersults at all? It's impossible for me to check each result, so I just want to make sure this won't affect anything I am doing. I assume it does not, but wanted to have all my bases covered before I submit this data for analysis. Thanks in advace, PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a drop down list include multiple cells? | Excel Discussion (Misc queries) | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
auto updating list | Excel Worksheet Functions | |||
Save trailing empty cells in a tab delimited text file | Excel Discussion (Misc queries) | |||
Copying values but skipping empty cells | Excel Worksheet Functions |