Update Column with condition

[ksarker]

How to update Column C with EXP and REV word 

1. if Column A first two digits are 15 then Column B # then replace Column C with "REV". 

2. if Column A first two digits are 17 then Column B # then replace Column C with "EXP".

Column A	Column B	Column
154589	#	n/a
17456	#	n/a
154589	#	n/a

[binuacs]

@ksarker One way of doing this

[FinnCharlton]

Hi @ksarker , here's a way to do this with a Formula tool:

Hope this helps!

[ksarker]

thanks both of them are helpful. but if i have more information such as below with two more rows then how to implement these formulas without having any change into last two rows (EXP, REV) because now it's changing all other items into NULL. I want to keep last two rows as it is no changes for last two rows.  

Column A	Column B	Column
154589	#	n/a
17456	#	n/a
154589	#	n/a
6504	ABC	EXP
4809	XYZ	REV

[BS_THE_ANALYST · Accepted solution]

@ksarker you just need to change @FinnCharlton 's logic slightly: