Vlookup

[Miriama_Q]

World Capitals
Country City
Argentina Buenos Aires
Belgium Brussels
Brazil Brasilia
Canada Ottawa
China Beijing
Cuba Havana
Czech Republic Prague
Denmark Copenhagen
Egypt Cairo
France Paris
Germany Berlin
Greece Athens
Hungary Budapest
India New Delhi
Iran Tehran
Italy Rome
Japan Tokyo
Kenya Nairobi
South Korea Seoul
Liberia Monrovia
Malaysia Kuala Lumpur
Mexico Mexico City
Nepal Kathmandu
Netherlands Amsterdam
Pakistan Islamabad
Poland Warsaw
Russia Moscow
South Africa Pretoria
Spain Madrid
Switzerland Bern
Turkey Ankara
Ukraine Kiev
United Kingdom London
United States Washington, D.C.

This spreadsheet is a simple list of world capitals. We'd like to make it easier to find the capital city for any country on this list. To do this, you'll create a VLOOKUP function. Keep in mind that this isn't a very realistic example of when you might use the VLOOKUP function — it's just a chance to try the VLOOKUP function without a lot of other complications.
a.Create a VLOOKUP function in cell E3 to find the capital city of Poland. You should be searching for an exact match. If you've added the formula correctly, it should return Warsaw as the result.

HOW CAN I SOLVE THIS??

 

[cyrilbrd]

Hi, read this:
[h=3]VLOOKUP Function[/h]<code style="box-sizing: border-box; margin: 0px; padding: 0px;"> =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
</code>

where: Argument Definition of argument
---------------------------------------------------------------------

lookup_value The value to be found in the first column of the array.

table_array The table of information in which data is looked up.

col_index The column number in the table_array for which the
matching value should be returned.

range_lookup It is a logical value that specifies whether
you want to find an exact match or an approximate match.
If TRUE or omitted, an approximate match is returned; in
other words, if an exact match is not found, the next
largest value that is less than the lookup_value is
returned. If FALSE, VLOOKUP finds an exact match. If an
exact match is not found, the #N/A error value is returned.


Note If range_lookup is TRUE or omitted (for an approximate match), the values in the first column of table_array must be sorted in ascending order. If range_lookup is FALSE (for an exact match), the table_array does not need to be sorted.[h=4]Example That Uses FALSE as the Range_lookup Argument[/h]The following list contains some fruits and their respective colors. Notice that the first column is not sorted: A1: Fruit B1: Color
A2: Kiwi B2: Green
A3: Banana B3: Yellow
A4: Grape B4: Purple
A5: Apple B5: Red


The following formula finds the color (Red) that corresponds to the fruit Apple. You can type the formula in any cell on the worksheet:<code style="box-sizing: border-box; margin: 0px; padding: 0px;">=VLOOKUP("Apple",A2:B5,2,FALSE)
</code>

Notice that if you change the range_lookup argument to TRUE, Excel returns the #N/A error, because the first column is not sorted.