Excel 97 query

[envelope]

I'm trying to set up a formula which will display text for a particular value. and put it in a table

For e.g. i have a row of four values 24 5 16 23, I've then created a formula that lists the highest two values, in this case 24 & 23.

I'm alright at this stange, what I'm unsure about is, the values 24 5 16 23 have names attached to them e.g one two three four. In the table that lists the wo highest values 24 & 23 I want it to display the corresponding name i.e

24 one
23 four

Then once the values differ the top two table changes, so if the four values are now 24 50 41 3, the table will display:

50 two
41 three.

I'm stuck on this problem if anyone can give me any help, it would be appreciated.

 

[Zelandakh]

When you say that you have names attached to them is it like this:

24 5 16 23
one two three four

elsewhere you have a column:
24
23

To the right of these calculations you want to put what is on the next ROW or the original data?

In that case use hlookup, if the original is in columns use vlookup.

So elsewhere you get:
24 vlookup(<cell with 24 in it>,<table>,2)

or similar.

Hope this helps.

 

[Lehtoant]

Remember to add the last parameter 0 to get exact match (=v/hlookup(<cell with 24 in it>,<table>,2,0)

Al