How can i get a specific cell content by specifying another

[adbadar]

How can i get a specific cell content by specifying another cell's content

For example
If i have 900 in C8 cell then get the content of A8
If i have 1 in C3 cell then get the content of A3

Any tips any suggestions

 

[HalfAce]

Re: How can i get a specific cell content by specifying anot

Hi,
Your request is a little vague.
In which cell(s) would you like to show the content(s) of A8 & A3 if the right conditions are met in C8 and(or) C3?
Are there any other conditions in which you want to display A3 & A8? or only if you have a 1 and 900 in C3 & C8?

Dan

 

[adbadar]

Re: How can i get a specific cell content by specifying anot

If i have 900 in C8 cell then get the content of A8 and place it in D8

 

[adbadar]

Re: How can i get a specific cell content by specifying anot

Actually First I want to get the Max Number between C5 and C14 Which i can do by (MAX(C5:C14)) and

for example

if i got Max Number which is in C8 then I want to get the content of A8 and display it into D10

if i got Max Number which is in C7 then I want to get the content of A7 and display it into D10

 

[HalfAce]

Re: How can i get a specific cell content by specifying anot

Well, this is pretty limited because I still don't know how your requirements may vary, but here's how you can do what you're showing me.
In cell D8, enter the following formula.
=IF(C8=900,A8,"")
(This should give you some ideas on how to do the rest.)

This help?
Dan

 

[HalfAce]

Re: How can i get a specific cell content by specifying anot

Give this a try & see if I understand what you want.
In cell D10:
=OFFSET(INDEX(C5:C14,MATCH(MAX(C5:C14),C5:C14,0),1),0,-2)
Dan

 

[adbadar]

Re: How can i get a specific cell content by specifying anot

Thanxxxxxxxxxxxx alot man!

 

[HalfAce]

Re: How can i get a specific cell content by specifying anot

You're most welcome. I think I first saw this here too.
(Probably from Yogi or JPG)