IF

[Burger]

Hi

Can somebody please tell me how to write a formula so
that if a cell has a particular value a further column
will show these numbers

3c=1
3b=2
3a=3
4c=4
4b=5
4a=6
etc.

Thanks

 

[Domenic]

Hi,

If I understand you correctly...

1) Select/highlight the number of cells you want showing your numbers.
In this example, we're only highlighting 6 cells in a column.
2) Press =
3) =IF(A1=10,{"3c=1";"3b=2";"3a=3";"4c=4";"4b=5";"4a=6"},"")
4) enter using CTRL+SHIFT+ENTER

where 10 is the number that we're comparing with A1

Hope this helps!

 

[Bob Phillips]

Here's another way

=MATCH(A1,{"3a","3b","3c","4a","4b","4c"},0)

 

[Frank Kabel]

Hi
I would set-up a lookup table with the associated values
and use VLOOKUP in your other sheet. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm