How to enter text with if condition

[tanmanoj]

Sir,

i attach a excel file in which i have column name subdiv_name at column F and i want to enter text automatically in corresponding column H where condition is if subdiv_name =H11 then fill the column against H11 with "division 1" or if subdiv_name = "h12" then "division 2" and so on i put it value manually in sheet please provide a formula for whole sheet to fill column

thanks

[ratcat]

G'day

Try this

Enter the formula in cell H2 then copy drag down.

=IF(F2="H11","Division 1","Division 2")

[tanmanoj]

thanks for your response but subdiv_name are more than two actullay then how to do it.

thanks

[Pepe Le Mokko]

Create a small table with the correspondences between the values, then use VLOOKUP to retrieve them

[tanmanoj]

how to do it ? please help with example
thanks

[benishiryo]

hi tanmanoj. so what are the other names? you can place all of them somewhere say in L2:L10 like:
H11
H12
H13
... and so on

then in M2:M10
Division 1
Division 2
Division 3
... and so on

in H2:
=VLOOKUP(F2,$L$2:$M$10,2,0)

[tanmanoj]

Great, i done it with this formula.


Please tell me what stands 2,0 in vlookup

thanks

[benishiryo]

2 is telling Excel you want the 2nd column from the table_array (where i selected $L$2:$M$10). 0 is equivalent to typing FALSE, and they both mean exact match for this formula.

the other option to the last argument of VLOOKUP is to use 1, TRUE or omit the last argument. that is to find approximate match. it's not for this case you have.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Pepe Le Mokko]

Great, i done it with this formula.


Please tell me what stands 2,0 in vlookup

thanks

XL as a help function activated by hitting F1. You then can find explanation on function syntax or many other things. I will refrain from further comment, though...