Good afternoon!
Sorry if I missed a topic where this question is addressed.
I have created a VLOOKUP formula to pull the address for a customer from a different sheet within the same workbook. The formula looks like this:
=VLOOKUP(A2, All!A2:AB350, 22, FALSE)
When I use the fill handle to add this formula to the cells below, it should change the first value (A2 should change to A3), but All!A2 should stay the same -- if it changes to All!A3 then by the bottom of the sheet the formula will only be looking in A350:AB350 and it will not be able to find the information I need.
Does anybody know how I could customize the fill handle so that it only changes the first value of the VLOOKUP formula? Alternately, is there a different way I can do this? I can probably create a macro, but that would take a long time!!
Thank you for your help!
Bookmarks