THE BEST

  Use VLOOKUP when you need to find things in a table or range by row. Select a cell. Type =VLOOKUP( and then select the value to lookup. Type a comma (,) and select the range or table to look for the value. Type a comma (,) and the number of the column where the lookup value is located. Type ,FALSE) to find an exact match. Press Enter. The formula for the video example is as follows: =VLOOKUP(A7, A2:B5, 2, FALSE). In its simplest form, the VLOOKUP function says: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).

  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. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on. Syntax The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.  =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])  Argument Description lookup_value Required* The value to search for *If omitted, XLOOKUP returns blank cells it finds in  lookup_array .    lookup_array Required The array or range to search return_array Required The array or ran...

  If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click   AutoSum   on the   Home   tab, press   Enter , and you’re done. When you click  AutoSum , Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click  AutoSum . A formula appears in cell B7, and Excel highlights the cells you’re totaling. Press Enter to display the result (95.94) in cell B7. You can also see the formula in the formula bar at the top of the Excel window. Notes:  To sum a column of numbers, select the cell immediately below the last number in the column. To sum a row of numbers, select the cell immediately to the right. AutoSum  is in two locations:  Home  >  AutoSum , and  Formulas ...

  Embassy of the Democratic People's Republic of Korea:     N 39, P. Suramarith St.  Tel: 426 848/015 839 680   Embassy of Australia:     Villa 11, St. 254  Tel:213 470, Fax: 426 003     Embassy of Brazil Darussalam:     N 237, St. 51  Tel: 211 457 - 458, Fax: 211 455 - 456     Embassy of Bulgaria:     N 227, P. Norodom Blvd.Tel: 723 182/015 915 825, Fax: 426 491     Embassy of Canada:     Villa 11, St. 254  Tel: 426 001-1, Fax: 426 271     Embassy of Cuba:     N 98, St. 214. Skt. Veal Vong  Tel: 217 428     Embassy of France:     N 1, P. Monivong Blvd.  Tel: 430 020, Fax: 430 037     Embassy of Germany:     N 76-78, St. 214  Tel: 216 381/216 193, Fax: 427 746    Embassy of India:     N 777, P. Monivong Blvd.  Tel: 363 502 / 361 270, Fa...

  Find out Useful Contacts, Public Services, Emergency Contact Numbers, Tourist office, Police, Fire, Ambulance, Traffic, Airports, Country Code, Local Area Access, Public Institutions when travelling in Cambodia. PUBLIC EMERGENCY CONTACTS 1- Tourist Police - Phnom Penh Phone:  012 942 484 Address: St. 598, 12107, Phnom Penh 2- Tourist Police - Siem Reap Phone:  012 402 424 Address: Mondul 3 Village, Sangkat Slor Kram, Siem Reap City, Siem Reap 3- Police - Phnom Penh Phone:  117 4- Fire Police Phnom Penh Phone:  118  or 011 997 296 Address: No. 58, St. 360, 12304, Phnom Penh 5- Calmette Ambulance - Phnom Penh Phone:  119  or 023 724 891 or 023 426 948 Calmette Ambulance (S.A.M.U.): 012 912 947 / 016 585 108 / 092 858 434 Address: No. 3, Preah Monivong (St. 93), 12201, Phnom Penh 6- Khmer - Soviet Friendship Ambulance - Phnom PenhPhone:   023 217 764 Address: Yothapol Khemarak Phoumin (St. 271), 12306, Phnom Penh 7- Preah Kossamak Ambulance - ...

  Country Country Code Afghanistan 93 Albania 355 Algeria 213 American Samoa 684 Andorra 376 Angola 244 Anguilla 1-264 Antarctica 672 Antigua 1-268 Argentina 54 Armenia 374 Aruba 297 Ascension 247 Australia 61 Australian External Territories 672 Austria 43 Azerbaijan 994 Bahamas 1-242 Bahrain 973 Bangladesh 880 Barbados 1-246 Barbuda 1-268 Belarus 375 Belgium 32 Belize 501 Benin 229 Be...