| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help..... 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help..... with formula
vlookup and match will do what I think you want
=vlookup(tsc_value,Entire_table_array,match(format ion_value,formation_row_array,0),false) -- paul remove nospam for email addy! "yhtak" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help..... with formula
I couldn't get that to work, I'm afraid. Must be me doing something wrong.
"yhtak" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help..... with formula
See response in excel.misc.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "yhtak" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help..... with formula
I tried this but I couldn't get it to work... it must be me!
"Bob Phillips" wrote: See response in excel.misc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "yhtak" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help..... with formula
You have more replies in .misc.
yhtak wrote: I tried this but I couldn't get it to work... it must be me! "Bob Phillips" wrote: See response in excel.misc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "yhtak" wrote in message ... 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? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
