Hi
I have the formula =VLOOKUP(A2,'ONS 2011'!$C$1:$L$292,COLUMN('ONS 2011'!B2),FALSE), which lets me drag it accross to pick the value in the next column i.e. 'ONS 2011'!C2' and so on. I would like to have the look value in A2 be locked going accros, but to chnge to A2, A3, as I drag it down.
In other words I would like A2 to be locked ($A$2) going accross rows, but change to $A$3, $A$4, $A$5 and so on going down the columns.
Thanks
Regards
Cortlyn
Just use 1 $ in front of what you want locked. So you want rows to change but not the column use $A2 (F4 is a shortcut which runs through the different configurations)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks