Hey everyone. Just a quick question. I searched on this first, but didn't find anything.
I have this formula: =VLOOKUP(C:C,Sheet2!A1:A10000,1,FALSE)
that I need to put in column A from 1 to 26,xxx. Is there a way to paste that formula in every cell down the column without the part in bold changing? I'm not too keen on hitting ctrl+v over 26 thousand times...
Thanks!
Last edited by Mallard; 02-19-2009 at 11:24 AM.
=VLOOKUP(C:C,Sheet2!$A$1:$A$10000,1,FALSE)
Awesome. That did it. Thank you.Originally Posted by johncassell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks