Excel Formula or Macro?

[Lynque]

Hello all,
I'm trying to populate a field based on one of seven values in another field...

eg.

If cell C3 = PC then B3 should = 1
else If cell C3 = MAC then B3 should = 2
else If cell C3 = NB then B3 should = 3
else If cell C3 = MON then B3 should = 4

and so on.

I'm relatively new to Excel so any and all help is appreciated

 

[Aladin Akyurek]

Hello all,
I'm trying to populate a field based on one of seven values in another field...

eg.

If cell C3 = PC then B3 should = 1
else If cell C3 = MAC then B3 should = 2
else If cell C3 = NB then B3 should = 3
else If cell C3 = MON then B3 should = 4

and so on.

I'm relatively new to Excel so any and all help is appreciated

=IF(LOOKUP(C3,{0,"MAC","MON","NB","PC"})=C3,LOOKUP(C3,{0,"MAC","MON","NB","PC"},{"",2,4,3,1}),"")

Or construct a sorted table as shown below...

Book5
	C	D	E	F	G	H	I
1					TABLE
2					Item	Num
3	MON	4	4		0
4					MAC	2
5					MON	4
6					NB	3
7					PC	1
8
9
Sheet1

and invoke:

=IF(LOOKUP(C3,$G$3:$G$7)=C3,LOOKUP(C3,$G$3:$H$7),"")

as shown in E4.