Designed, engineered and assembled in the United States, YORK® home heating and air conditioning systems are efficient, reliable and easy to use.
We support a variety of YORK ® commercial industries to fit your needs, including data center cooling solutions, higher education HVAC solutions, government facility HVAC equipment, healthcare, sports and entertainment climate control, and more.
Explore YORK Residential Products. Discover reliable and efficient HVAC solutions for every home.
With YORK® residential heating and cooling systems, home comfort is smarter, more efficient and more reliable than ever before.
At YORK®, comfort is more than a feeling – it's a promise: to innovate, to assure and, most of all, to deliver. Find out how we leverage our unparalleled residential dealer network and world-class commercial support services to lead the industry.
Technical support from the experts at YORK®, including contact information for specific product categories.
YORK HVAC products include YORK air conditioners, home AC units and other residential HVAC products with great YORK warranty options and home HVAC support.
The YORK® Dealer Success program offers the industry's most complete set of independent HVAC contractor support tools to help your business reach new heights. With our industry-leading marketing programs, you’ll have the tools needed to generate new leads, close more sales and achieve your business goals.
YORK commercial HVAC equipment includes packaged ducted systems, packaged HVAC units, split system equipment and ducted systems split system.
York Stock Chiller - Chiller Selection Guide Find the Right Chiller, Right Here Speed selection of YORK ® air- and water-cooled chillers, get real-time availability and product details, and streamline quoting and purchase.
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price.
Use the VLOOKUP function to look up a value in a table. The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. Lookup_value can be a value or a reference to a cell.
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel.
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.
The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column. The following is an example of LOOKUP formula syntax:
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
In this case there is no "Banana" listed in the lookup table, so VLOOKUP returns a #N/A error. Solution: Either make sure that the lookup value exists in the source data, or use an error handler such as IFERROR in the formula.