 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006PLEASE HELP - COPY VLOOKUP
Someone tried to help me but I didn't had any results... I'm working on a two worksheets. The formula is as follows: =VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE LIST'!$A:BE;57;0) I want to copy the formula to one cell on the right and turns as follows: =VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE LIST'!$A:BF;57;0) My problem is that the coll index number does not change... that means I have to change it manually for 50 collumns. PLEASE HELP $A92 is an absolute column, A92 is relative and changes when copied  SignatureKind regards, Niek Otten Microsoft MVP - Excel | Someone tried to help me but I didn't had any results... | [quoted text clipped - 14 lines] | | PLEASE HELP Thank you, but I don't want to change the "look up value", I want the "colindexnumber" (from 57 to 58, to 59 etc). Any other idea? I also tried to put the column (ie BB:BB) instead of the number but it didn't work also. > $A92 is an absolute column, A92 is relative and changes when copied > [quoted text clipped - 16 lines] > | > | PLEASE HELP It does here SignatureKind regards, Niek Otten Microsoft MVP - Excel | Thank you, | [quoted text clipped - 26 lines] | > | | > | PLEASE HELP > .. I want the "colindexnumber" (from 57 to 58, to 59 etc). Try replacing the constant col index num: "57" in your vlookup with: COLUMN(A1)+56 The col index num will now increment correctly when you copy across SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- Max Thank you!!! It worked! > > .. I want the "colindexnumber" (from 57 to 58, to 59 etc). > > Try replacing the constant col index num: "57" in your vlookup > with: COLUMN(A1)+56 > The col index num will now increment correctly when you copy across You're welcome ! SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Max Thank you!!! > > It worked! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.