 |
 | 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 / Worksheet Functions / March 2008Lookup and offset at the same time?
Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT I've used MATCH and INDEX for this type of thing in the past. Unfortunately, Excel is tied up on this machine right now, so can't give any more details.  SignatureHTH, Barb Reinhardt > Hi, > I am not sure how to accomplish this task. [quoted text clipped - 9 lines] > Thanks > TedT Try this: =INDEX(A:A,MATCH(MAX(F:F),F:F,0)) SignatureBiff Microsoft Excel MVP > I've used MATCH and INDEX for this type of thing in the past. > Unfortunately, [quoted text clipped - 17 lines] >> Thanks >> TedT Worked fine, Thank you > Try this: > [quoted text clipped - 21 lines] > >> Thanks > >> TedT You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > Worked fine, > Thank you [quoted text clipped - 28 lines] >> >> Thanks >> >> TedT Maybe you're trying to do something like this, in say G1: =INDEX(A:A,MATCH(MAX(F:F),F:F,0)) G1 returns the value in col A corresponding to the max in col F. If there's ties in the maximum values in col F, it'll return only the the value corresponding to the 1st maximum (the one higher up) SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hi, > I am not sure how to accomplish this task. [quoted text clipped - 9 lines] > Thanks > TedT Thanks for the help, I got it working. TedT > Maybe you're trying to do something like this, in say G1: > =INDEX(A:A,MATCH(MAX(F:F),F:F,0)) [quoted text clipped - 15 lines] > > Thanks > > TedT Welcome, Ted. Take a moment to press the "Yes" button below to the question: "Was this post helpful to you?" from where you're reading this. It'll ensure a longer shelf life to this thread for the general benefit of other readers. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Thanks for the help, I got it working. > TedT >Take a moment to press the "Yes" button below >to the question: "Was this post helpful to you?" Done! SignatureBiff Microsoft Excel MVP > Welcome, Ted. Take a moment to press the "Yes" button below to the > question: [quoted text clipped - 4 lines] >> Thanks for the help, I got it working. >> TedT |
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.