Hi Folks,
First, thanks for helping to keep this forum up and running for those of us who are looking for help in using Excel. While I'm learning a lot by reading and watching how-to videos, there are still some problems that I can't figure out, in part because I don't really know how to refine my searches to specify precisely what I'm looking for. So my apologies if the question I ask is one that's already been answered.
Here's my problem:
I'm using VLOOKUP to cross-reference data on two different sheets, with the lookup value data on one sheet (let's say Sheet1) and the table array data on another (Sheet2). I have no problem getting VLOOKUP to populate Sheet1 with the relevant data from Sheet2. What I'm attempting to do is use the Fill Handle to apply VLOOKUP across multiple columns on Sheet1. This works easy-peasy if, when entering the second argument, I switch to Sheet2, highlight the relevant cells, and hit the comma key to have VLOOKUP enter the selected range into the function. When the function is fully written, I can use the Fill Handle to click and drag VLOOKUP across multiple columns and every cell populates with the required data. If, however, I name my table array using the Define Name option and then input that name into the VLOOKUP function, I am not able to successfully click and drag the Fill Handle across multiple columns without getting the #N/A error.
In other words, using something like this allows me to use the Fill Handle to apply the VLOOKUP results across multiple columns:
Formula:Please Login or Register to view this content.
But using something like this doesn't:
Formula:Please Login or Register to view this content.
Would any of you gents or ladies be able to tell me why that's happening? And is there a way for me to use the Fill Handle tool across multiple columns, if my table array argument has a defined name?
Bookmarks