bertusgeert 1 #1 February 15, 2011 I just made the switch the Excel 2010. I love some things, and I hate some things. My main issue is this - I rely heavily on inter-worksheet Vlookups, which in 2003 stayed relative when I changed columns in my source. in 2010, every time (vlookup or not) I change a source file, the reference is lost. There must be a setting somewhere.... Other than that I'm pissed I can't navigate the filter solely with my keyboard anymore - I am now forced to go slow and click and unclick #N/A's etc. Thanks for messing up my expediency & flow, Microsoft.... --------------------------------------------- As jy dom is moet jy bloei! Quote Share this post Link to post Share on other sites
regulator 0 #2 February 15, 2011 Try this, the column index will increase as you paste the formula (to the right): =VLOOKUP(L4,'[mail.xls] new'!$A$6:$AB$261,COLUMNS($A$1:F$1),FALSE) Quote Share this post Link to post Share on other sites
