If/Then formula question

[JToddHubbard]

I want to create a formula that will reference a spreadsheet of areas codes and their timezones. If the area code in a cell on the original sheet matches an area code on the reference sheet then in a seperate cell, I want the time zone of the area code displayed.

 

[Special-K99]

Use VLOOKUP or MATCH

 

[Stan_C]

For what you've provided, this should work being copied down.


Sheet14

*	A	B	C	D
Sheet 1	*	Sheet 2	*
Atlantic	No Match
Eastern	Eastern
Central	Central
Atlantic	Atlantic
Eastern	No Match

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]3103[/TD]

[TD="align: right"]3101[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]3101[/TD]

[TD="align: right"]3101[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]3102[/TD]

[TD="align: right"]3102[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]3105[/TD]

[TD="align: right"]3105[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]3108[/TD]

[TD="align: right"]3103[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula D2 =IF(A2=C2,B2,"No Match") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4