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?

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?

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?

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?

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?

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