Function or Formula to show the value from above cell
 

Hi everybody , and a good day !

A B C D E
row 1 1 2 3 4 5
row 2 2 4 7 1 88
row 3
row 4

I need a function or formula , which if in
row 2 , range A2:E2 , the value is 1 (for
eg.) , to return me the value of above cell
of the value I look for ;
In this case , to return value 4 ;
If I look for value 88 in row 2 , range
A2:E2 , to return 5 .
Thank you very much for your knowledge
share .

Function or Formula to show the value from above cell
 

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)


On 2 Cze, 12:17, ytayta555 wrote:
Hi everybody , and a good day !

* * * * * *A * * B * * C * * D * *E
row 1 * *1 * * 2 * * 3 * * *4 * * 5
row 2 * *2 * * 4 * * 7 * * *1 * *88
row 3
row 4

I need a function or formula , which if in
*row 2 , range A2:E2 , the value is 1 (for
eg.) *, to return me the value of above cell
of the *value I look for ;
In this case , to return value 4 ;
If I look for value 88 in row 2 , range
A2:E2 , to return 5 .
Thank you very much for your knowledge
share .

Function or Formula to show the value from above cell
 

On 2 Iun, 13:37, Jarek Kujawa wrote:
for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !

Function or Formula to show the value from above cell
 

pls click YES if it helped

thks for the feedback


On 2 Cze, 12:50, ytayta555 wrote:
On 2 Iun, 13:37, Jarek Kujawa wrote:

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !

Function or Formula to show the value from above cell
 

Please understand.
Saying "pls click YES ..." is a waste of your time and ours unless the
person to whom you are replying happens also to be posting his message
through Microsoft's web interface to the newsgroup. For the rest of us who
post to the newsgroup by more conventional means, the talk of a YES button
is meaningless, and for newer contributors to the group it is confusing.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
pls click YES if it helped

thks for the feedback


On 2 Cze, 12:50, ytayta555 wrote:
On 2 Iun, 13:37, Jarek Kujawa wrote:

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !

Function or Formula to show the value from above cell
 

And, I feel it is much better to go thru the email route such as.

Setting up Outlook Express/Windows Mail to access Microsoft newsgroups
http://www.michaelstevenstech.com/ou...snewreader.htm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Please understand.
Saying "pls click YES ..." is a waste of your time and ours unless the
person to whom you are replying happens also to be posting his message
through Microsoft's web interface to the newsgroup. For the rest of us
who post to the newsgroup by more conventional means, the talk of a YES
button is meaningless, and for newer contributors to the group it is
confusing.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
pls click YES if it helped

thks for the feedback


On 2 Cze, 12:50, ytayta555 wrote:
On 2 Iun, 13:37, Jarek Kujawa wrote:

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !

Function or Formula to show the value from above cell
 

I DO understand that
Now "Please understand" Dave
I did not mean to waste YOUR time
though I think you're wasting it to frequently for posting meaningless
comments to my posts
thanks anyway

don't click YES if it helped


On 2 Cze, 14:06, "David Biddulph" <groups [at] biddulph.org.uk wrote:
Please understand.
Saying "pls click YES ..." is a waste of your time and ours unless the
person to whom you are replying happens also to be posting his message
through Microsoft's web interface to the newsgroup. *For the rest of us who
post to the newsgroup by more conventional means, the talk of a YES button
is meaningless, and for newer contributors to the group it is confusing.
--
David Biddulph

"Jarek Kujawa" wrote in message

...



pls click YES if it helped

thks for the feedback

On 2 Cze, 12:50, ytayta555 wrote:
On 2 Iun, 13:37, Jarek Kujawa wrote:

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

Function or Formula to show the value from above cell
 

thanks Don, I'll consider that
however I cannot do it from my office


On 2 Cze, 14:28, "Don Guillett" wrote:
And, I feel it is much better to go thru the email route such as.

* * * Setting up Outlook Express/Windows Mail to access Microsoft newsgroups
* * * http://www.michaelstevenstech.com/ou...snewreader.htm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David Biddulph" <groups [at] biddulph.org.uk wrote in ...



Please understand.
Saying "pls click YES ..." is a waste of your time and ours unless the
person to whom you are replying happens also to be posting his message
through Microsoft's web interface to the newsgroup. *For the rest of us
who post to the newsgroup by more conventional means, the talk of a YES
button is meaningless, and for newer contributors to the group it is
confusing.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
pls click YES if it helped

thks for the feedback

On 2 Cze, 12:50, ytayta555 wrote:
On 2 Iun, 13:37, Jarek Kujawa wrote:

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

Function or Formula to show the value from above cell
 

You do yourself NO favor by alienating a frequent and helpful poster. I
think he was just trying to help you understand that not all use that method
and the click IS meaningless. My thought is that no one looks anyway.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jarek Kujawa" wrote in message
...
I DO understand that
Now "Please understand" Dave
I did not mean to waste YOUR time
though I think you're wasting it to frequently for posting meaningless
comments to my posts
thanks anyway

don't click YES if it helped


On 2 Cze, 14:06, "David Biddulph" <groups [at] biddulph.org.uk wrote:
Please understand.
Saying "pls click YES ..." is a waste of your time and ours unless the
person to whom you are replying happens also to be posting his message
through Microsoft's web interface to the newsgroup. For the rest of us who
post to the newsgroup by more conventional means, the talk of a YES button
is meaningless, and for newer contributors to the group it is confusing.
--
David Biddulph

"Jarek Kujawa" wrote in message

...



pls click YES if it helped

thks for the feedback

On 2 Cze, 12:50, ytayta555 wrote:
On 2 Iun, 13:37, Jarek Kujawa wrote:

for 88
=OFFSET(A2,-1,MATCH(88,A2:E2,)-1)

It work perfect !! You're great , Thanks so much !- Ukryj cytowany
tekst -

- Poka¿ cytowany tekst -