2 questions on referencing other cells

[bustanutti21]

Does anyone know how (or if you even can) make the information from one cell generate depending on whats in another...

for example...

if in cell A2 i have 160
A3 195
A4 180
and i need B2 to say T@3
B3 to say T@1
A4 to say T@2

because in our system, we have rates and numbers that are used to code those rates... 195 - 1
180-2
160-3

I have another question along the same lines but in different context.. I'll wait to see if i can get this one done first... no need to over load..

[dacius1]

Is the value in a column always consistent?

meaning.... is 195 always 1, 180 always 2 etc.

[bustanutti21]

yes..
195 will always be T@1
190 will always be T@2
185 T@3

and so on

I just want it generate the T@whatever when i type in the rate (195, 185 etc)

[dacius1]

yes..
195 will always be T@1
190 will always be T@2
185 T@3

and so on

I just want it generate the T@whatever when i type in the rate (195, 185 etc)

a vlookup will work wonders here then.

you need to make a vlookup like the one I have here in the sample


test sample.JPG

Also if the file you are making is large then remember to include the $ symbols before the rows of the table_array so when you scrool down the formula your table remains consistent.

[Carim]

Hi,

In cell B2, type following formula

="T@"&RANK(A2,$A$2:A4)

and copy it down ...

HTH
Carim