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
1	Sheet 1	*	Sheet 2	*
2	3103	Atlantic	3101	No Match
3	3101	Eastern	3101	Eastern
4	3102	Central	3102	Central
5	3105	Atlantic	3105	Atlantic
6	3108	Eastern	3103	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>
</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