excel formula

S

snwooz

I have a set group of numbers associated with letters. I need to know what
formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the letter
show up inj another are.

Thanks:)
 
F

Franz Verga

snwooz said:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)
Click to expand...


You can use a VLOOKUP formula; you can build a Vlookup table and use the
formula, or just incapsulate the table into the formula.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
S

snwooz

I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)
 
S

snwooz

OK, first post put me on the right track. I have on that works, now i need
to it work for all 5 numbers.

Thanks
 
F

Franz Verga

snwooz said:
I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)
Click to expand...

=VLOOKUP(A1,{1.26,"G";1.22,"C"},2,0)

where A1 is your input cell.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
S

snwooz

PERFECT!!!! tHANKS:)

Franz Verga said:
=VLOOKUP(A1,{1.26,"G";1.22,"C"},2,0)

where A1 is your input cell.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
Click to expand...
 
S

snwooz

IS it possible to set the formula to go either way. If A1 and B1 are my
input cells, can the formula work so that if I put in 1.26 in A1, G comes up
in B1 or if I put G in B1, 1.26 comes up in A1?
 
F

Franz Verga

You have to decide which are your input cells and which are the result
cells: in a cell you can have a result from a formula or an input, not
both...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top