 |
 | 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 / July 2006Help..... with formula
A sample of the data I'm working with looks like this: Formations 313** 313**313** 317** 317**317** TSC 21960000 12.737 21961000 10.259 21962000 11.584 12.860 24.542 21963000 13.155 21964000 14.038 21965000 14.333 15.511 32.200 21967000 11.293 12.762 24207000 I am trying to write a formula which will return the value of, for example, TSC 2196200 and formation 317**. I 'm sure it's easy bit for the life of me I can't get it to work. Can someone help please? vlookup and match will do what I think you wan =vlookup(tsc_value,Entire_table_array,match(formation_value,formation_row_array,0),false)  Signaturepaul paul.shepherd@nospamparadise.net.nz remove nospam for email addy! > A sample of the data I'm working with looks like this: > [quoted text clipped - 12 lines] > TSC 2196200 and formation 317**. I 'm sure it's easy bit for the life of me > I can't get it to work. Can someone help please? I couldn't get that to work, I'm afraid. Must be me doing something wrong. > A sample of the data I'm working with looks like this: > [quoted text clipped - 12 lines] > TSC 2196200 and formation 317**. I 'm sure it's easy bit for the life of me > I can't get it to work. Can someone help please? See response in excel.misc. SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > A sample of the data I'm working with looks like this: > [quoted text clipped - 12 lines] > TSC 2196200 and formation 317**. I 'm sure it's easy bit for the life of me > I can't get it to work. Can someone help please? I tried this but I couldn't get it to work... it must be me! > See response in excel.misc. > [quoted text clipped - 16 lines] > me > > I can't get it to work. Can someone help please? You have more replies in .misc. > I tried this but I couldn't get it to work... it must be me! > [quoted text clipped - 25 lines] > > me > > > I can't get it to work. Can someone help please? SignatureDave Peterson |
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.